|
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 |
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 |
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 |
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 |
Including a range of number in a IF (Logical Test) formula
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 |
| All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com