ok, for some reason i cannot write a new post (maybe i can only have one?).
So i will ask it he how can i add to an "if" function. As in, i want to
say =IF M626 AND T6<135, "1st class"

can i do this, and effectively add two conditions for one if statement?

"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?