Rounding down from .9 in an IF stmt

[Guest]

I am working on a project, if a score is anywhere between 69.5 to 69.999999,
I need it to round down to 69, not round up to 70.
This is the formula I have in under Grade %
=IF(E70="","",(E70/C70)*100)
The correct answer is 69.6, but for this particular course, if the student
scores anything below a true 70% they must retake the test. So, I need it to
round anything below a true 70 down to 69.

Number of Number Number Grade
Questions Wrong Correct %

50 15.20 34.80 70

Thank you for your input.

 

[daddylonglegs]

Try using FLOOR or ROUNDDOWN, e.g.

=IF(E70="","",FLOOR(E70/C70*100,1))