Thread: How do I calculate variance percetage if figures are negative
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default How do I calculate variance percetage if figures are negative
Shouldnt that be

=(A1-B1)/A1

If this post helps click Yes
---------------
Jacob Skaria


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

Reply With QuoteReply With Quote