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?

Formula for difference between numbers without + or-
 

=ABS(A1-B1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ParvenuJohn" wrote in message ...
| 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?
|

Formula for difference between numbers without + or-
 

On Tue, 23 Oct 2007 03:56:00 -0700, ParvenuJohn
wrote:

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

Formula for difference between numbers without + or-
 

=ABS(A3-B3)

Regards,
Soundar.

"ParvenuJohn" wrote:

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?

Formula for difference between numbers without + or-
 

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

Thanks again

ParvenuJohn

"Soundar" wrote:

=ABS(A3-B3)

Regards,
Soundar.

"ParvenuJohn" wrote:

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?