What you are seeing is simple round-off eror. The reason that different
things are displayed is probably due to formatting differences.
--
Gary's Student
"Steven_Archer" wrote:
problems with TRUNC
--------------------------------------------------------------------------------
Hi,
I seem to be having trouble with the TRUNC formula!
In the same worksheet i have used it many times but some seem to give
the incorrect answer...but all the settings are the same as the one
that works!
the formula is =TRUNC(W152/60)
where in this case W152 is 180.
in some of the cells the result of =TRUNC(180/60) = 3
in the ones which are not working the result is 2.9999999999999
Any ideas? all the formulas and cell settings are identical!
--
Steven_Archer
------------------------------------------------------------------------
Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025
View this thread: http://www.excelforum.com/showthread...hreadid=487571