function

[Guest]

I need a formula that does the following:

A student's grade on a test is in cell B5. Write a formula in cell C5 to
curve that grade. IF the grade is 60 or greater, add 5 points to the grade.
If the grade is below 60, make the grade 60.

 

[Guest]

In C5:
=IF(B5>=60,B5+5,60)

 

[Guest]

Thanks...but if the grade is below 60, I need the grade to be 60.....

 

[Guest]

Sure, that's exactly what that formula does.

If the first condition fails (the grade isn't 60 or above... a.k.a. "greater
than or equal to"), the only other option is for the grade to be strictly
less than 60, so you don't need a check for it. That is the default
condition.

 

[Guest]

Thank you so much....it did work ;-)

Sure, that's exactly what that formula does.

If the first condition fails (the grade isn't 60 or above... a.k.a. "greater
than or equal to"), the only other option is for the grade to be strictly
less than 60, so you don't need a check for it. That is the default
condition.