Thread: Difference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stevep-4 Stevep-4 is offline
external usenet poster
 
Posts: 3
Default Difference

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.