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.