How to Calculate Percent Difference Between Two Numbers in Excel

Learn how to calculate the percent change or difference between two numbers in Microsoft Excel.

Using the formula: percent difference = (new value - old value)/(old value)*100, we can calculate the percent difference between two numbers.

[bikassingh]

Don't know why people disliked such informative video. Short and clear without bullshit

[JohnstasBACK]

You, sir, just did my homework. I plugged in all of my values and your formula gave me the results! Thank you. I owe you some drinks.

[sheethalrajanna]

Very short and precise!! This is what answer to the point called as! Just loved the video!

[srikantheqt]

Thanks for a vdo. Nice to understand. 28.4.2020; from India; 11.30; afternoon; seeing this vdo in lockdown period, due to covid19. Stay home and stay safe to all people in the world.

[fabulous_Analytics]

Very informative and straight to the point

[bhavapritaapara]

This is fantastic. Short crisp and problem solving

[mohamadzakibinmohammadazam]

Thank you so much for this video sir, very helpful 🙏✨

[Banknifty_shark]

MUST NEEDED FORMULA THNX VERY MUCH....

[amitajoshi]

if you were to calculate difference from 2017 to 2019, would you use different approach?

[Narendra]

Nice thank you, I have little confusion then its clear..

[zameergul]

very nice
you solved my problem
Thank you very much

[jackrozzariya]

Thank you so much dear. God bless you.

[tadhana]

how do i get the total assets of the percentage change

[elliewood]

How do you do this but across two sheets?

[willhatt]

i have done this exact formula but when i have a larger number in column D it shows a different percentage. for instance, column D has 95 and C has 5 it shows as 1800%. any idea what i can do to change this?

[csinclair]

Came for the formula, stayed for the birds.