View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade
 
Posts: n/a
Default how do i display a variance in all positive numbers?


I am not sure if I understand what you are asking, but I will take a
stab at it.

I am assuming that both of the numbers are positive, (you can't have a
negative operating margin, can you?) So you can simply do a =A1-B1 to
get the difference, assuming column A is planned and column B is
actual.

If you want to difference to be a positive number, put a ABS before you
formula, =ABS(A1-B1)


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=555607