Non-signed Difference between 2 cells
 

rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))
or
applying special formating to the cell to suppress the "-" sign,

Surely there must be a worksheet built-in function to give me the difference
between two cells.

Can anyone help?
Thanks a mil
Cherft

Hi cherft,
rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))

=abs(a1-b1)

arno

One way:

=ABS(A1-B1)

In article ,
cherft wrote:

rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))
or
applying special formating to the cell to suppress the "-" sign,

Surely there must be a worksheet built-in function to give me the difference
between two cells.

=ABS(A1-B1)

- Mangesh



"cherft" wrote in message
...
rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))
or
applying special formating to the cell to suppress the "-" sign,

Surely there must be a worksheet built-in function to give me the
difference
between two cells.

Can anyone help?
Thanks a mil
Cherft

Many thanks indeed - appreciated
regards
Cherft

"arno" wrote:

Hi cherft,
rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))

=abs(a1-b1)

arno

Many thanks indeed - appreciated
regards
Cherft

"JE McGimpsey" wrote:

One way:

=ABS(A1-B1)

In article ,
cherft wrote:

rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))
or
applying special formating to the cell to suppress the "-" sign,

Surely there must be a worksheet built-in function to give me the difference
between two cells.

Many thanks indeed - appreciated
regards
Cherft

"Mangesh" wrote:

=ABS(A1-B1)

- Mangesh



"cherft" wrote in message
...
rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))
or
applying special formating to the cell to suppress the "-" sign,

Surely there must be a worksheet built-in function to give me the
difference
between two cells.

Can anyone help?
Thanks a mil
Cherft