Yeah, its using that decimal number in the calculation, I dont want it
to do this. The sheet I am using is using hh:mm as its dimensions, so
I am trying to keep all the cells displays in the same dimension but
the calc. is calculating in those decimals. Here is the formula for
cell I6...=1-F6/F6+AA6+AB6....but I only want this formula to use AB6
if the value in AB6 is greater than 0.....if you can help with that it
will also be appreciated.

thks


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555974