function
 

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.

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

--
Regards,
Dave


"stacy" wrote:

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.

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

"David Billigmeier" wrote:

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

--
Regards,
Dave


"stacy" wrote:

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.

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.
--
Regards,
Dave


"stacy" wrote:

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

"David Billigmeier" wrote:

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

--
Regards,
Dave


"stacy" wrote:

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.

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

"David Billigmeier" wrote:

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.
--
Regards,
Dave


"stacy" wrote:

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

"David Billigmeier" wrote:

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

--
Regards,
Dave


"stacy" wrote:

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.