# 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

Andy February 18, 2020 4:47 pm

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

ANGA PYDIRAJU February 18, 2020 4:47 pm

Maam your awesome

Chuck Riesterer February 18, 2020 4:47 pm

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

George Reynolds February 18, 2020 4:47 pm

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

rasal sheikh February 18, 2020 4:47 pm

Tnx to share

Budi Nugraha February 18, 2020 4:47 pm

how to calculate for this case.

actual 2019 = -2

target 2020 = 3

growth = ? (formula)

Huma February 18, 2020 4:47 pm

Thank you so very much

Your videos have been really really helpful

Thanks

Maher Ahmed February 18, 2020 4:47 pm

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 🙂

Robbie Knott February 18, 2020 4:47 pm

Thanks!!! Love your work.

Anne Lopez February 18, 2020 4:47 pm

Amazing 🙂

Phil Wilkinson February 18, 2020 4:47 pm

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.

Archie White February 18, 2020 4:47 pm

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.

N SundaraMoorthy February 18, 2020 4:47 pm

Fantastic.

dark thunder February 18, 2020 4:47 pm

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

Ahmed Saeed February 18, 2020 4:47 pm

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

YAIR GS February 18, 2020 4:47 pm

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

rkagi February 18, 2020 4:47 pm

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)

Carlos lopez lozano February 18, 2020 4:47 pm

Thanks for the video! easy!

Mo naz February 18, 2020 4:47 pm

Is percentage change the same as percentage variation ?

Badreddin Alsabbagh February 18, 2020 4:47 pm

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

MATRIX GHOST February 18, 2020 4:47 pm

I was distracted the whole time by that angelic face

Iscoal Michael February 18, 2020 4:47 pm

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

Sylvie Morissette February 18, 2020 4:47 pm

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

Janet Lamb February 18, 2020 4:47 pm

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

George Reynolds February 18, 2020 4:47 pm

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

gulshan jii February 18, 2020 4:47 pm

I love you mam

Andrzej Andrzejos February 18, 2020 4:47 pm

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

txreal February 18, 2020 4:47 pm

100% cool video

505 Strat February 18, 2020 4:47 pm

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

rajendra badhori February 18, 2020 4:47 pm

You are great. Your video really helped me.

Jojo YZ February 18, 2020 4:47 pm

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

Andrew Muir February 18, 2020 4:47 pm

This is maths not excel

Shlomo Batsia February 18, 2020 4:47 pm

Basic indeed, but always nice to remember…

chaz kaz February 18, 2020 4:47 pm

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

T Hyslop February 18, 2020 4:47 pm

This is fourth grade math, maybe third.

arif hidayat February 18, 2020 4:47 pm

Love it …thank you Leila