00:00Assalamu alaikum friends, in today's video we will learn how to make excel formula workable
00:10For example, I am using this formula
00:14For example, I am multiplying this
00:23I have put this formula here
00:26And when I drag it, all the cells are getting similar amount
00:32For example, if I change any value, the formula is not changing
00:39So how can we fix this?
00:41For this, first you have to click on the file
00:44And below you have to click on the option
00:47After clicking on the option, you will get the formula option
00:51You have to click on it
00:53You will get the calculation option
00:56The formula I have clicked on is manual
01:00So I have to click on automatic
01:03And after that I will click on ok
01:06So you can see that all the figures are updated automatically
01:10So this way you can accurate your formula automatically
01:15I hope you like this video
01:17If you like this video, please support my channel
01:20Thanks for watching
Comments