Mortgage Calculator

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

36 comments

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

    Reply
  2. Maam your awesome

    Reply
  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!!

    Reply
  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%.

    Reply
  5. Tnx to share

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

    Reply
  7. Thank you so very much
    Your videos have been really really helpful
    Thanks

    Reply
  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 🙂

    Reply
  9. Thanks!!! Love your work.

    Reply
  10. Amazing 🙂

    Reply
  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.

    Reply
  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.

    Reply
  13. Fantastic.

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

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

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

    Reply
  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)

    Reply
  18. Thanks for the video! easy!

    Reply
  19. Is percentage change the same as percentage variation ?

    Reply
  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
    your method will show: -100%

    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

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

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

    Reply
  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%)))

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

    Reply
  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").

    Reply
  26. I love you mam

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

    Reply
  28. 100% cool video

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

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

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

    Reply
  32. This is maths not excel

    Reply
  33. Basic indeed, but always nice to remember…

    Reply
  34. Videos are amazing. Watched you do this in IF functions and was slightly confused. Thanks for clearing up

    Reply
  35. This is fourth grade math, maybe third.

    Reply
  36. Love it …thank you Leila

    Reply

Leave a Reply