Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Including a range of number in a IF (Logical Test) formula
Isn't there a "RANGE" formula that can be used complimentary with the IF
formula? I am grading some students' work and am looking to have a IF formula that divides the students' numeric points earned by the number of possible points and have the conditions be as follows: RANGE GRADE ..9-1 A ..8-.89 B ..7-.79 C ..6-.69 D 0-.59 F What I tried was this: =IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F")))) However, this did not work because I am either using the RANGE formula incorrectly or this formula doesn't even exist. -Zakhary |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Including a range of number in a IF (Logical Test) formula
try this idea
IF(C7/C6.9,"A"),IF(C7/C6.8,"B"),ETC -- Don Guillett SalesAid Software "Zakhary" wrote in message ... Isn't there a "RANGE" formula that can be used complimentary with the IF formula? I am grading some students' work and am looking to have a IF formula that divides the students' numeric points earned by the number of possible points and have the conditions be as follows: RANGE GRADE .9-1 A .8-.89 B .7-.79 C .6-.69 D 0-.59 F What I tried was this: =IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F")))) However, this did not work because I am either using the RANGE formula incorrectly or this formula doesn't even exist. -Zakhary |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Including a range of number in a IF (Logical Test) formula
Try this:
=IF(COUNT(C6:C7)<2,"",LOOKUP(C7/C6,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"})) Biff "Zakhary" wrote in message ... Isn't there a "RANGE" formula that can be used complimentary with the IF formula? I am grading some students' work and am looking to have a IF formula that divides the students' numeric points earned by the number of possible points and have the conditions be as follows: RANGE GRADE .9-1 A .8-.89 B .7-.79 C .6-.69 D 0-.59 F What I tried was this: =IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F")))) However, this did not work because I am either using the RANGE formula incorrectly or this formula doesn't even exist. -Zakhary |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Including a range of number in a IF (Logical Test) formula
Zakhary
No such function as RANGE Try this as an alternative. =LOOKUP(C7/C6,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"}) Gord Dibben MS Excel MVP On Sat, 30 Dec 2006 11:02:00 -0800, Zakhary wrote: Isn't there a "RANGE" formula that can be used complimentary with the IF formula? I am grading some students' work and am looking to have a IF formula that divides the students' numeric points earned by the number of possible points and have the conditions be as follows: RANGE GRADE .9-1 A .8-.89 B .7-.79 C .6-.69 D 0-.59 F What I tried was this: =IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F")))) However, this did not work because I am either using the RANGE formula incorrectly or this formula doesn't even exist. -Zakhary |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Including a range of number in a IF (Logical Test) formula
=.9
-- Don Guillett SalesAid Software "Zakhary" wrote in message ... The only problem with this resolution is thaty it only will include numbers that are greater than .9, but not equal to. .9 need to be included -- -Zakhary "Don Guillett" wrote: try this idea IF(C7/C6.9,"A"),IF(C7/C6.8,"B"),ETC -- Don Guillett SalesAid Software "Zakhary" wrote in message ... Isn't there a "RANGE" formula that can be used complimentary with the IF formula? I am grading some students' work and am looking to have a IF formula that divides the students' numeric points earned by the number of possible points and have the conditions be as follows: RANGE GRADE .9-1 A .8-.89 B .7-.79 C .6-.69 D 0-.59 F What I tried was this: =IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F")))) However, this did not work because I am either using the RANGE formula incorrectly or this formula doesn't even exist. -Zakhary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
How do I enter formula that adds a range if less than a number or | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula for displaying the lowest number of a range? | Excel Worksheet Functions |