I get 79.6. You must have the cell formatted to show 0 decimals.
If you want integer values, use
=IF((100-(((I2)-0.75)*144))100,100,ROUNDDOWN((100-(((I2)-0.75)*144)),0))
this gives 79 with you I2 value
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Desdinova" wrote in message
...
i am trying to get excel to round down (instead of round up) the result of
the following formula:
=IF((100-(((I2)-0.75)*144))100,100,(100-(((I2)-0.75)*144))). the input in
I2
is 21:24, which is in the [h]:mm format. The answer is 79.6, but excel
will
by default display 80. I have noted the =ROUNDDOWN function, but i do not
know if it can be applied within another formula. If so, then how? If not,
then how can i get the result to round down?