# Compute Percentages the Correct Way in Excel (% Alter & Total following % raise)

Verify the Excel Essentials Study course:

How to estimate percentages in Excel. Understand how to exhibit knowledge efficiently for reports for example when calculating percentage modify (p.c raise or reduce) from Actual to Finances or this 12 months to earlier 12 months.

Also find out how to estimate the remaining sum following a p.c raise or p.c reduce. For example if you have a 10% value raise – what is your remaining value?
You also have to have to be careful when inputting percentages in Excel. I exhibit you diverse methods on how to do this appropriately.

This math percentage tutorial applies to calculating percentage modify in all variations of Excel and also outside of Excel.

⯆ Down load the workbook below:

Excel Basic principles Playlist:

★ My On the internet Excel Classes ►

✉ Subscribe & get my Top 10 Excel formulas e-e book for free of charge

EXCEL Means I Recommend:

Get Place of work 365:
Microsoft Floor:

Gear
Digicam:
Display recorder:
Microphone:
Lights:

Far more means on my Amazon site:

Take note: This description consists of affiliate inbound links, which indicates at no more cost to you, we will receive a smaller commission if you make a obtain making use of the inbound links. This helps help the channel and makes it possible for us to continue on to make videos like this. Thank you for your help!

#MsExcel

resource

1. You just helped me calculate my total take home amount after a pay my realtor. Thank you.

3. EXACTLY what I needed. I'm working with budget information, and this was perfect. And right at the beginning of the video. Thank you!!

4. Thank you, Leila! Be wary of margin and markup – e.g. cost= \$80 and sale price = \$100; the markup is 20/80 = 25% but the margin is 20/80 = 20%.

5. Tnx to share

6. how to calculate for this case.
actual 2019 = -2
target 2020 = 3
growth = ? (formula)

7. Thank you so very much
Thanks

8. I am so surprised! I was thinking about how to calculate the change in variance analysis – believe me once I opened youtube it showed the useful video – was that by chance? Leila covered every valuable tips 🙂

10. Amazing 🙂

11. Hi
Leila, thanks for the video as everyone is saying your videos are great. But i have a question now it might be my math / or some error on my part that is the problem but why can you not reverse this. So assuming that A2 is actual and budget is B2.
=A2*(1+10%)
would give us actual +10% (so if actual is 100, and budget is 10% more then budget would be 110
) now if i wanted to check that increase could use
=A2/B2-1
But that show 9.09% not the 10% i asked to be added to. i would have expected to see 10% here the same as i specified.

12. Great video. Someone might have already mentioned this but I was always taught to mark up using P/(1-%) and down using P*(1-%) that way if you mark and and then back down you end up the same number. Using the method you describe you will not get the starting value.

13. Fantastic.

14. again and again i wont stop thanking you 🙂 love your videos

15. Good stuff. How about irregular percentage increase in n years? Is there Leila version channel for Word?

16. No deberías explicar temas en los que no estás muy segura. Se nota tu inseguridad al exponer un poco de álgebra.

17. Leila, for short timeframes, you can also calculate % change as ln(new/old).

That way, if you have a sequence of events, such as daily stock market data, you can just sum the % change of a range (ie week) to get the % change in that range (ie for that week)

18. Thanks for the video! easy!

19. Is percentage change the same as percentage variation ?

20. Thank you for all the videos I learned a lot from you, I have one question
How do you find the percentage increase in a negative number?
for example:
previous year: -3,162
current year: 13

do you recommend to use ABS function to solve the wrong result?
BTW I have more than 100,000 data line in Excel, so I prefer to use one method that works for both positive and negative numbers

21. I was distracted the whole time by that angelic face

22. This particular video is one of a kind, but guess what? you are such a genius!

23. Thank you for all that amazing info. I have made a function with many "IFS" and I was wondering if there would be a shorter function that would give me the same result … I have to pay different percentages of taxes on different amounts; <=5,000 x 6% & <=15,000 x 11% & >15,000 > 16% ….. this function works but very long ….. would you have a better one =IF(\$N\$15<=5000,\$N\$15*6%,IF(\$N\$15<=15000,\$N\$15*11%,IF(\$N\$15>15000,\$N\$15*16%)))

24. Can I ask what is the signficance of the either -1 at the begining of the formula or the end of the formula

25. Excellent, Leila! A lot of people – especially in the media – misuse percentages. For example "the amount of sales decreased by 200%" – impossible! Or "they increased by 300%" when a threefold increase was what happened, that should have read "they increased by 200%" (or better "to 300% of the initial figure").

26. I love you mam

27. Your videos are nice to watch, hear and are helpful also. Damn thats fair enough to subscribe

28. 100% cool video

29. Another way of calculating actual value is: (You = VeryCool)

30. You are great. Your video really helped me.

31. I am new here. Really nicely delivered your knowledge! Love from Pakistan 💓

32. This is maths not excel