View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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.