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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"stacy" wrote in message
...
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