How to Calculate Percent Variance in Excel - Office 365

A percent variance is a percentage change between two numbers, an old value and a new value. You can calculate the percent variance by subtracting the old value from new value and dividing the result by old value and change the format of the cell to percentage number format.

[@gigler1990]

Thank you for your help! Excellent video.

[@FindEasySolution]

Glad to help. Please subscribe to our channel.

[@shuvomdutta7901]

Thanks for the wonderful help.

[@FindEasySolution]

Glad to help. Please subscribe to our channel.

[@deliciouslifestyle9130]

I did not understand the last step, why did he the variance percentage twice and subtract 1?

[@captainarshad5425]

Wow nice one sir

[@FindEasySolution]

Thank you for the appreciation

[@bushraahmad8008]

What if there are more than 2 tables to find out the variance??

[@Mad1080]

Excellent explanation sir... Please make more video of FP &A, Budgets, Forecasting, Mainly in analysis area...
Please attached the excel for reference....

[@FindEasySolution]

Thank you for the appreciation. All recent videos the example excel file can be downloaded from description.

[@tomalavi87]

thank you!

[@FindEasySolution]

You are welcome

[@raghavendrabhat3668]

What if instead sales it OI and is negative? In this case it shows positive percentage