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
|