How do I calculate variance percetage if figures are negative
Try
=(ABS(A-B)/ABS(A))*100
Using absolute values should solve your problem.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"MJ" wrote:
I am trying to calculate the variance percentage in a profit & loss account
in excel. I am using the formula (a-b/a)*100, which works ok except when one
or both of the figures is negative. The result is showing positive instead of
negative and vise-versa.
|