Non-signed Difference between 2 cells

[cherft]

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

[arno]

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

=abs(a1-b1)

arno

[Mangesh]

=ABS(A1-B1)

- Mangesh



"cherft" <[email protected]> wrote in message
news:[email protected]...
> 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

[JE McGimpsey]

One way:

=ABS(A1-B1)

In article <[email protected]>,
cherft <[email protected]> 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.

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

[cherft]

Many thanks indeed - appreciated
regards
Cherft

"JE McGimpsey" wrote:

> One way:
>
> =ABS(A1-B1)
>
> In article <[email protected]>,
> cherft <[email protected]> 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.
>

[cherft]

Many thanks indeed - appreciated
regards
Cherft

"Mangesh" wrote:

> =ABS(A1-B1)
>
> - Mangesh
>
>
>
> "cherft" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>