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.

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

or

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


On Sun, 18 Sep 2005 14:50:01 -0700, "stacy"
wrote:

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.

You've also got some responses
in your multi-post over in .worksheet.functions ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--