alter to:
=TRUNC((W152/60),0)


"Steven_Archer"
wrote in message
news:Steven_Archer.1yy4ha_1132743008.4391@excelfor um-nospam.com...

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=487564