Thread: function
View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

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.