Help...if formula

[Guest]

I need a formula that does the following...if a grade is 60 or greater, add 5
points to it. If the grade is between 50 and 60, add 10 points to it. If the
grade is below 50, make it 60.

 

[Myrna Larson]

=IF(A1<50,60,IF(A1<60,A1+10,A1+5))

or

=A1+IF(A1<50,60-A1,IF(A1<60,10,5))

 

[Max]

You've also got some responses
in your multi-post over in .worksheet.functions ..