Formula for difference between numbers without + or-

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ParvenuJohn - 23 Oct 2007 11:56 GMT

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 to this Message

Niek Otten - 23 Oct 2007 12:13 GMT

=ABS(A1-B1)

Signature

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
[quoted text clipped - 6 lines]
|
| How do I do this please?

Reply to this Message

Ron Rosenfeld - 23 Oct 2007 12:19 GMT

>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
[quoted text clipped - 6 lines]
>
>How do I do this please?

=abs(a1-a2)
--ron

Reply to this Message

Soundar - 23 Oct 2007 13:28 GMT

=ABS(A3-B3)

Regards,
Soundar.

> 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
[quoted text clipped - 6 lines]
>
> How do I do this please?

Reply to this Message

ParvenuJohn - 23 Oct 2007 22:13 GMT

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

Thanks again

ParvenuJohn

> =ABS(A3-B3)
>
[quoted text clipped - 11 lines]
> >
> > How do I do this please?

Reply to this Message

Rate this thread: