Difference
=B1-A1 gives 245 with your example numbers, Excel knows elementary maths, why
didn't you try it?
Regards,
Stefi
€˛Stevep-4€¯ ezt Ć*rta:
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.
|