View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default My formula returns a result but the cell displays a zero?

According to your formula, you are subtracting something (XX) from
itself (XX) which will always equal zero. Out of curiosity, why use
the SUM function. Isn't it easier to just type the equation such as...

= A1 - A2

- John Michl