how to round down the result of a formula
Or if you want to use ROUNDDOWN, you can try
=MIN(100,ROUNDDOWN(100-(I2-0.75)*144,0))
for zero decimal places, or
=MIN(100,ROUNDDOWN(100-(I2-0.75)*144,n))
to round down to n decimal places.
--
David Biddulph
"JE McGimpsey" wrote in message
...
One way (to round down to the nearest integer):
=MIN(100,INT(100-(I2-0.75)*144))
In article ,
Desdinova wrote:
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?
|