View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Lost4Now
 
Posts: n/a
Default Format Cells - Accounting - Discrepancy?


Jim, finally caught on to what you where saying about not _exactly_
zero.

You suggested the following {You might try setting "Precision as
Displayed" on under Tools, Options, Calculation.} Haven't gone there -
will check it out though.

I used an IF function "=IF(C95+A96-B96<0.01,0,C95+A96-B96)". No more
"$ (0.00)" - I've got my "$ - " back - THANKS A MILLION for
responding.

Dean Thomas


--
Lost4Now
------------------------------------------------------------------------
Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
View this thread: http://www.excelforum.com/showthread...hreadid=508457