00:00Hello friends, Assalamualaikum, in today's new video we will learn how to calculate percentage change in excel.
00:07I have this data, it has old prices and new prices.
00:11How can we calculate the percentage change between these two values?
00:15First of all, you have to mark it as is equal to.
00:18After that, you have to open parenthesis, which we also call bracket.
00:22And after that, you have to take new values, and after that you have to minus the old values from it.
00:29And you have to close parenthesis, that is, you have to close the bracket.
00:32After that, you have to divide it, and after that you have to enter the new old price and enter it.
00:42After that, you have to correct the percentage mark from here, and you can also increase its value from here.
00:51And you have to drag down from here.
00:53So, look here, you have this percentage change between two.
00:57I hope you have understood how to calculate the percentage change between new price and old price.
01:03So, if you like this video, then please support my channel.
01:06Thanks for watching.
Comments