Formula for difference between numbers without + or-

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=ABS(A1-B1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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?
|
 
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?
Click to expand...

=abs(a1-a2)
--ron
 
Thanks everyone - I think I now have the basic formula, which is "ABS" I will
try it.

Thanks again

ParvenuJohn
 
Back
Top