Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |