Thread: Formula for difference between numbers without + or-
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ParvenuJohn ParvenuJohn is offline
external usenet poster
  
Posts: 2
Default Formula for difference between numbers without + or-
I'm fairly new to Excel. I want to create a formula to show the difference
between 2 numbers, in different columns, but without positive or negative
values.
eg. the difference between 1 and 7 is 6. The difference between 7 and 1 is 6.

I do NOT want to see the result as -6 and 6.

Imagine the cells are A3 and B3, for these numbers.

How do I do this please?

Reply With QuoteReply With Quote