Formula for difference between numbers without + or-

[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?

 

[Niek Otten]

=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?
|

 

[Ron Rosenfeld]

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-a2)
--ron

 

[Guest]

=ABS(A3-B3)

Regards,
Soundar.

 

[Guest]

Thanks everyone - I think I now have the basic formula, which is "ABS" I will
try it.

Thanks again

ParvenuJohn