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

"Susan" wrote:
I am working with a spreadsheet that has an operating margin and a planned
operating margin and some months I have a postive OM and some months a
negative OM but when I display the variance between the two I'd like to
display the variance as just a number


=abs(A1-B1)