if formula
 

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

Here is the equation you requested

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

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


"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

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