hi
try
=SUM(XX,(-XX)


-via135


Excel User Wrote:
I have a simple formula subtracting one cell from another using
=SUM(XX,
-XX). When I click on fx and bring up the function arguments box, the
formula result is displayed correctly in that box. However, the cell
containing the formula will only display a zero. I have tried
reformatting
the cells to no avail. I have also tried getting a result using =XX-XX
and
that does not work either.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=502600