if formula

[Guest]

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

 

[Barb Reinhardt]

Here is the equation you requested

=IF(A2>60,A2+5,IF(AND(A2<60,A2>50),A2+10,IF(A2<50,60)))

You didn't consider if the value was =50, or =60 however.

 

[Max]

Just another play to try ..

Assuming Grades are listed in A2 down

Put in B2:
=IF(A2="","",IF(A2<50,60,
SUM(A2,VLOOKUP(A2,{50,10;60,5},2))))

Copy B2 down