I did try that and it still return a zero value in the actual cell, although
as before, if I open the function arguments pop up box, the correct value is
listed there.
Any other ideas why a function result would display correctly in the
arguments box but a completely different number display in the cell itself?
"via135" wrote:
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