Maybe a slight tweak

=ABS(A1-B1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Roger Govier" wrote in message
...
Hi Steve

Why not just =A1-B1 ?

--
Regards

Roger Govier


"Stevep-4" wrote in message
...
I am sure there is a very simple answer to this.

I need to calulate the difference between 2 cells (each cell is a SUM
of the
information of other cells).

the content of each of these cells could be +ve or -ve. Thus, if A
is -45
and B is 200, then the difference is 245.

Is there a simple was of doing this, rather than a long winded IF IF
IF
command.