Calculate Percentage in Excel the Right Way (% Change & Amount after % increase)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/percentage-change-file

[@CHARETAKKY]

🙏🙏🙏🙏👏👏👏👏

[@dekebell3307]

I learn something EVERY time I watch your videos. Thank you!!!

[@msmith3090]

My wife teaches these percent applications to junior highers. They do it by hand instead of in Excel. She said your approach to writing the formulas gave her new ideas on how to explain it to them. Thank you!

[@michaelamccurry6899]

I would rather do it by hand

[@christoslefkimiotis9889]

Having seen a lot of your videos I have to congratulate you on your detailed approach to any issue that you are trying to explain. I consider myself an advanced excel user and still there are bits that I am learning from you. I see a lot of %changes as my daily job and I see people struggling. First you have to identify your starting point and then identify your terminal point. For example Budget sales is my starting point and the Actual sales my finishing point (it can easily be the other way around, depending on what you want to present). With the %chnage we are trying to find out what is the number to add on top of the budget sales (starting point) so to arrive to the actual sales (finishing point). And always the %change = (Terminal point / Starting point -1), that is the only that you have to remember so in your example is Actual/Budget-1. You might have year1 and year2 data the %change is different if the starting year is year1 and different if is year2, but always the correct formula is (Terminal point / Starting point -1). Special cases If year1 sales=120 and year2=0, then the %(year2 vs year1) = (-100%) but if year1=0 and year2=120 the %change is not defined as there is no number to multiply 0 (the starting point) and arrive to 120 (finishing point). As an analyst when I came across these cases I rather have a text saying something like "No sales in previous year" but not +100% that is totally incorrect.

[@LeilaGharani]

Very good explanation. Thanks for the valuable feedback Christos!

[@chuckriesterer8284]

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

[@LeilaGharani]

My pleasure Chuck.

[@karhukivi]

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/100 = 20%.

[@elbaymammadyarov8120]

margin is 20/100 = 20%

[@karhukivi]

@@elbaymammadyarov8120 Correct!

[@gregorgeorge8868]

Leila, you are my saver, You help me every time. THX. BR from Slovenia.

[@matthiasheuer]

You explained that very well and understandably, Ms. Leila Gharani. I always enjoy watching your videos.

[@Look4chrisng]

Thanks I been calculating percentage for 20 years in excel, Never thought of this smart way to do it.

[@ssergeant9682]

I know enough about xcel to be dangerous. seriously thinking about taking one of your courses but not sure what I need. I'm a small business owner (semi-retired) applying for PPP loan and needed to get percentages of loss from 2019 - 2020. your formula was just what I needed. need to wait for PPP grants or loans before spending any money but am now subscribed. thank you. currently using xcel 2010 but I think I have a newer version. just not installed

[@LeilaGharani]

Welcome aboard!

[@Haywoodma419]

I watched your video this morning and used it already in the afternoon. Thanks, keep them coming.

[@LeilaGharani]

Awesome! Thank you!

[@netsurfers9357]

I use DAX all the time and love learning from your tutorials and not only that you are a beautiful intelligent lady!

[@naboulsikhalid7763]

how person dislike this video and its content. Leila did huge effort to simplify, make easy to understand and hoe to implement the subject. moreover, she explained a nuances too. thank you Leila for your generous knowledge sharing and all you've done.

[@LeilaGharani]

I appreciate that!

[@Highway123456789]

This is my go to lady for Excel questions! Thank you!

[@karhukivi]

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

[@islandcave8738]

Yes, and years ago I explained to someone that 100% more then is the same as 200% as much of. I might have a problem too where when media makes this mistake I interpret it as what they said actually means and not what maybe they might actually mean. It's not my fault I'd they are saying it wrong.

[@massimoriggio6297]

We all love you, you are a big source of knowledge for the entire world, thanks for what you do.

[@bonifaciojr.piedad4021]

There is one vlogger . Its channel is innorative. He discussed computing growth. This his formula =(current-previous)/current

[@dushyantbhati2722]

Sister your videos are very knowledgeable. Love and respect from India

[@razvanrinder617]

Hi Leila, I have an amendment for your formula. In Excel if you want to find out what percentage represent a value from a different one the right formula I've found (I'm using EXCEL 2007) is: =((new value cell/initial value cell -1)+1). In this way, if I am formatting the cell as "%" the result showed will be exactly the value of the percentage I am looking for. Thank you for your work!

[@tkosse]

This was good. Thanks. Could you do a quick video on the best way to calculate compound annual growth rate using Excel?

[@remediationdepartment4332]

I always watch your videos with great interest. Thank you very much!!

[@petersmith8134]

Brilliant. Exactly what I was trying to do. Thank you!!!!!!!

[@rkagi]

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)

[@deondunn3074]

Thanks for the video. Simple and easy to understand.

[@LeilaGharani]

You're welcome, Deon!

[@venukrishna8453]

Was Always looking for this concept.. Finally found it. Thanks for teaching elemental basics and then excel!

[@j4v33d]

You are awesome and thanks for sharing such valuable tips

[@Betterifitsfree]

Dayum! You Rock. I was playing with this not long ago and had to give up because I was making all the mistakes you mentioned. Thank you for all your help.

[@LeilaGharani]

You're very welcome. I'm glad you found this useful.

[@charalampos4016]

I have been being in the generic finance industry in Greece for about 12years. Recently I noticed your videos and your channel and I think of them as the best I have ever seen in this subject, though I am an excel savy, and excel is my daily working tool for a decade and the subject of my training duties to new staff. However I didn't get the purpose of this video.

[@charalampos4016]

I am sorry, I watched the video again. At least in Greece, if your boss found out that you watched this video in order to managed to report % changes you are fired. Except for the cases you are someone of his relatives or a relative of a polititian.

[@LeilaGharani]

@@charalampos4016 Your comment made me laugh :)

[@willie3528]

I finally want to learn how to work with excel and this will be a great learning base.

[@markwilliamson6820]

Excellent, as usual. You explain things clearly and concisely. For me, this one wasn't as useful as the others. I'm a certified high school teacher, so I know the math, and I learned spreadsheets on Supercalc 5.1 ( ever heard of that??), so the cell formulas were pretty straightforward. However, this brings us back to my first point: excellent, as usual. Since many people doing this work may not know the math, it's great that you cover it, just to be sure. I think people would rather learn math from you, as they need it, than suffer in my math class. LOL. This is really a great service you are doing. Thank you, and God bless you!

[@LeilaGharani]

Thanks for the kind words Mark. I'm glad you like the videos. I'm sure no one is suffering in your class :)

[@Llb890]

I have learned so many idea from your videos.please keep teaching us.

[@LeilaGharani]

I'll definitely do that. Glad to hear the tutorials are helpful.

[@compufama4678]

I couldn't concentrate admiring your beauty. Thank goodness I found you. I have to do a price increase to my inventory (1000+ products). I'm going to buy the course. You just made me the day *night. Thank you!

[@LeilaGharani]

That's great. I hope you'll enjoy the course.

[@Shng1968]

Thank you so much for the video on percentage increase and decrease.

[@LeilaGharani]

You're most welcome.

[@ernman681]

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.

[@LeilaGharani]

I'm not a mathematician but I disagree. Let's say we increase from 100 to 120. That's an increase of 20% on a base of 100. My calculation would be 120/100-1 = 20%. However, by using your formula for marking up I get to 125: 100/(1-20%)=125. The other way, if we go from 120 to 100 that's a reduction of -16,67% from a base of 120. Or, did I misunderstand your calculation?

[@ernman681]

@@LeilaGharani What I am talking about is this: If I buy product A at $100 and I want to make a 20% margin on it, then using P/(1-%) will give me $125. 80% of 125 of 100 the original cost. 25 is 20% of 125 the margin I wanted. This is how all sales software I have seen works. See this for a much more elegant descripton mathcentral.uregina.ca/QQ/database/QQ.09.06/h/drew1.html Please don't get me wrong though, I love your videos

[@RahulKumar-zv2nd]

Very nice video, you are very good to simplify every problem . Keep posting such informative videos. Thanks for sharing !

[@LeilaGharani]

Glad you find the video helpful!

[@CKBREEZY7]

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

[@LeilaGharani]

Glad it's helpful.

[@ckokse]

Gotta have the basics covered. Many thanks for the nice tutorial.

[@LeilaGharani]

You're very welcome :)

[@livinindubai]

I’ve improved my excel skillz thanks to this channel 👍🏼

[@LeilaGharani]

Thank you very much for your support. I'm very glad to hear that.

[@livinindubai]

Hi, thanks for your reply! If I can request for a tutorial it would be how to calculate payback period in a nice presentable way.

[@okpukokofrancis4821]

Wow..This is very good ...i learnt a good lesson from it. Thanks.

[@LeilaGharani]

Glad it was helpful!

[@premiumgold6802]

thank you. I like the way you teach. very helpful to me.

[@LeilaGharani]

Thank you. I'm glad you like the video!

[@anishpillai]

These formulas are really helpful. Thanks for this video. However I have a tip for anyone who wants to use these formulas. When I work with clients or fresh recruits or sometimes even my boss 😀, I find it easy to explain it to them by using the formula in layman terms. For example %change would be (Actual-Budget)/Budget.

[@figlermaert]

Anish Pillai agree.

[@iduncanw]

Much easier to understand and explain. Basically the difference divided by the starting figure.

[@josephalaguna]

This one was a huge efficiency for me!

[@NandaKumar-vg9oy]

Cool. Makes learning so meaningful. Thanks for sharing the tips.

[@knotdavewalker]

Always clear, Thank You

[@RMKserve]

Smart trainer Leila and smart tricks♥️❤️

[@jaykiriona]

Thank you! So simply laid out, appreciate it.

[@LeilaGharani]

You're very welcome!

[@donnaassenza3025]

Thank you so much for the explanation. I have seen the formula used but didn't understand.👌

[@LeilaGharani]

You're very welcome Donna.

[@alakanandadev6155]

Thank you I liked that . I can use it for my students.

[@LeilaGharani]

Great!

[@pavol.cernak]

Hi Leila, could you please use your charming style of teaching and English, and explain audience the following: when the VAT increases from 20% to 21%, the increase is not by 1% but by 5%. Many people do not understand this, even editors in TV, newspapers etc. Thank you 😉.

[@XLGuy]

Thank you Leila for your amazing tutorials, this one is so basic yet highly needed one. Absolutely loved this.

[@andrewmoss6449]

Really useful guide about percentages. Thanks!

[@firojahmad8980]

Thanks Leila Gharani for your smart video !!!

[@s-mall6418]

Very very helpful. Now I have a situation. Try to help me please. 1. We have 50 students with random class admitted in different years 2. But from 30 family How can I easily group the siblings of each family. *Assume parent details mismatch* Hope I could make it clear to you 🙏🏻🙏🏻

[@Lu11ss]

A very good video!! Congrats; greetings from Brazil

[@LeilaGharani]

Thank you Luis! Cheers!

[@rlionheart8657]

Thank you Leila. Other ways to do basic math formulas would be nice. You could make it a special series of videos.

[@ExcelExciting]

Lovely .. straight & clear.!!!

[@ParadoxGD]

always love you. i bought your course on udemy and it's really useful for my work. thanks for always update new trick.

[@datalab365]

Good day Leila, I am one of your students on Udemy. Please how can I calculate the cost of goods sold if I have different prices for one product, e.g one product has a carton price, a dozen price, quarter price, and unit price. I will be happy if you can demonstrate that mam.

[@anshuiway]

It's a very nice trick to get result of percentage changes. Thanks to sharing this video.

[@LeilaGharani]

You're very welcome.

[@higeorge3926]

I like your explanations very much. Can i have a formula to enter a date automatically when we enter data in the adjoining cell.

[@sosoboss]

Thanks you so much for your videos. You are a very good teacher in excel. I have learned a lot through your videos. Even if I'm french, I can understand easely what you said, because you have a very good skills in teaching. So, I'm waiting for new videos, especially about datavisualisation and making beautiful graphs. I hope you can understand me, I'm sorry for my english.

[@LeilaGharani]

I'm very glad you like the videos!

[@iscoalmichael3117]

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

[@faizandhami]

understood . good teaching

[@badreddinalsabbagh3963]

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

[@LeilaGharani]

How about this: IF(OLD

[@badreddinalsabbagh3963]

​@@LeilaGharani Thank you it worked but if the negative number is larger than the positive number it will show a misleading result, for example: Previous year: -153,080 Current year: 152,080 Result: -0.65%

[@irviantantohaditomo8917]

Love you Leila. Many thanks for your video tutorial. I have improved my skill in ms excel.

[@yulinliu850]

Thanks Leila! I teach statistics and very happy to see your lecture!

[@kazisazzad9257]

Great! It is inspiring! It made my job easier. Thank you!

[@tramasdelahistoria]

thank you lol, I needed this for my macroeconomics class

[@sarfarajkureshi6569]

Nice video I need it, first time I see you while teaching on board....

[@LeilaGharani]

Glad it is helpful. Thought I use the board and change things up a bit :)

[@dejabluek8297]

THANK YOU for this video. This is the help I needed to simplify my formulas.

[@LeilaGharani]

You're very welcome.

[@rmjaln]

Was taught an easy way to remember percentages framed by a question “what percentage is B of A” = formula will be “is over of x 100” Eg B divided by A multiplied by 100 - excel formula =(B1/A1)x100

[@ibrahimzimit6241]

Beautiful soul! Quite rich, thank you dear

[@skgaming1806]

Thank You Very Much Leila Gharani I like your video very much

[@Sachin19831000]

Thanks for valuable information 🙏🏻

[@koz.b1741]

Hey Leila, you are always making it so simply for all. I have an issue i think only you can help. i have a list of daha 100 cells vertically, all numbers. I need to to see if the numbers go from one point to another and drop %50 . Like 1 3 8 7 6 4 - price moved from 1 to 8 and back to %50 And if possible i want to calculate if it goes up after %50 and back down. I hope you see it.

[@wannabedal-adx458]

simple enough and that's ok. Sometimes a review of the simple things is important!! Thanks, Leila!

[@patricia5121]

You rock! I became your fan. Your videos are spectacular.

[@LeilaGharani]

I'm happy to hear that Patricia. Great to have you here!

[@reachbhanuchandran]

Thank you, Leila! You are a godsend!

[@fahimamf]

thank you for your efforts

[@maherahmed2018]

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

[@HarisKhan-mn9cj]

It's really amazing video and so helpful tips Thanks for sharing

[@LeilaGharani]

You're very welcome. Glad it's helpful.

[@wmfield152]

What an amazing lesson! Thanks L.

[@abdulrenishr]

Good voice,presentation and clarity u preserve

[@abuferasabdullah]

Abdul Renish And hot also 😍

[@venkateshmondati2963]

explained that very well and understandably

[@LeilaGharani]

Glad it was helpful!

[@scottgerlach6867]

Thank you. Great lessons!

[@codewithgedo3067]

you are really a great teacher I have never seen like you before. I have some confusing thing is that, I want to now how can I post all the transaction from general journal to ledger "by used one or more of Excel Functions" ? Thank you so much for 💓 I'm waiting for your reply.

[@LeilaGharani]

Not sure I can help you there. You need to create a download from your GL into a CSV or text file.

[@usefulstuff8435]

I like the way you use the whiteboard to explain algebra. What's your degree?

[@sachinrv1]

Leila, you made me look back in past in my math's class. The only difference; my teacher was not adorable as you are :) :). Thanks for upload. By the way let me share formula of Future Value based on the % trick that you showed. E.g. how much $ 10000/- become after 6 years giving interest rate of 8.16% compounded annually. No need to use any financial function of Excel. The simple way is =10000*(1+8.16%)^6. If its semi-annually compounding then divide the interest rate by 2; multiply the power by 2= 10000*(1+(8.16%/2))^12 and same way for quarterly output..

[@LeilaGharani]

That's great! Thank you for sharing Sachin.

[@olusegunaina9097]

Thanks Sachin. This came in handy

[@sachinrv1]

@@olusegunaina9097 Thanks Aina; one more formula of EMI; little lengthy, but once you get hang of this no need to use PMT function of Excel: 1. Divide the interest rate by 12 2. Multiply the principle amount by the result in point (1) 3. [1+result in point (1)]^ no of months 4. Result in point (3) -1 5. Finally, Result in point (2) multiply by Result in point (3) and divided by Result in point (4) IS THE EMI (equated monthly installment). You can surely try this; not even a single penny difference will come if you cross check with PMT function; Certain things are really fun when done in CLASSIC WAY :)

[@olusegunaina9097]

@@sachinrv1 wonderful Sachin. Thanks

[@GeertDelmulle]

This “devide the percentage by the number of periods” argument always gets me. Let’s focus on a particular example: yearly vs. monthly. If your yearly% = 12%, how much is the equivalent monthly% ? And then: why? What reasoning do you follow?

[@sametsevim8681]

you are the best , thank for all sharings and posts

[@krishnateja297]

Hi Big fan of your stuff Can you make a course for financial analysis

[@deepakv.2528]

Thank you Leila for posting an instructive video. I wanted to ask (just to clarify, I am a new excel enthusiast) if we had figures in one column and the percentages in the next column by which they are either increasing or decreasing. Would you please show how to use excel to automate the new amounts in the 3rd column? Many thanks in advance.

[@LeilaGharani]

All you would have to do is to reference the original values and multiply it with (1+ the percentage in the other column). Something like this in C1: =A1*(1+B1)

[@deepakv.2528]

@@LeilaGharani Same formula would apply to the whole column whether we have percentage values in negative or positive? Thanks for your prompt replies, much appreciated.

[@violetpraveen]

Hi thanks for your support I have a question Can we record calls live by macros Kindly suggest

[@huma848]

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

[@LeilaGharani]

My pleasure. I'm glad you like the videos.

[@mezianeremila454]

Always good to review the very basics...

[@sumittrox143]

*Wasted whole night using a calculator & manually entering % addition data*- Now I have learned the time-saving way. Much appreciated & thanks for your efforts

[@LeilaGharani]

Glad it helped!

[@patrickvazeille6972]

THANK YOU SO MUCH Leila for this vidéo

[@practicecomputing8506]

Version 2010 and on (not sure about earlier) of the pivot table does this also. Even if you prefer the worksheet with formulas, it's a great way to check.

[@casper3842]

your awesome! i learned 2 things in one day and applied those in my work....

[@LeilaGharani]

Perfect! I'm glad to hear that.

[@daarkthunderr]

again and again i wont stop thanking you :) love your videos

[@nirmalbudhathoki2564]

Thank you so much for very great video. It helps me lots. I have a question, related with IF function. my question is : Richard asks you to calculate the membership prices for the first quarter memberships sold in the gallery ticket office. The individual membership price is $50. Students pay a discounted price of $25. In cell F5, create a formula using the IF function to determine the membership price based on the following criteria: a. If cell D5 (the Category) is Student the price is 25. (Hint: Student must appear in quotes. Do not enter $ for the price.) b. All other individual members must pay 50. Copy the formula in cell F5 into the range F6:F13.