Help with an IF statement please...

[Shhhh]

Hello all...

I have a column with these values (A+, A, A-, B+, B.....) and I am
trying to assign numerical values to each grade I thought I had the
formula down but I keep getting error messages... can you please tell
me what I did wrong...

Here is what I tried to enter...

=if((if(D143="A+","100",IF(D143="A","95",IF(D143="A-","90",IF(D143="B
+","89",IF(D143="B","85",IF(D143="B-","80",IF(D143="C
+","79",IF(D143="C","75",IF(D143="C-","70",IF(D143="D
+","69",IF(D143="D","65",IF(D143="D-","60",IF(D143="N/
A","0","")))))))))))))))

Any and all help greatly appreciated!

 

[ozgrid.com]

Use a Lookup table with VLOOKUP
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/lookup-table.htm

 

[Lee Li Fong]

You can also try this formula,
=LOOKUP(A1,{"A+","A","A-","B+","B","B-","C-","C","C+","D","D-","N/A"},{100,95,90,89,85,80,79,75,70,69,65,60,0}

Lee Li Fon
http://smartusemicrosoftoffice.blogspot.com

 

[Ron@Buy]

Shhhh if your using XL2007 then modify your formula to
=IF(D1="A+","100",IF(D1="A","95",IF(D1="A-","90",IF(D1="B+","79",IF(D1="C","75",IF(D1="C-","70",IF(D1="D+","69",IF(D1="D","65",IF(D1="D-","60",IF(D1="N/A","0",""))))))))))
However if you have XL2003 or earlier it won't work as XL2003 only accepts 7
'IF' statements

 

[helene and gabor]

col B col C
A+ 100
A 95
A - 90
B+ 89
B 85
B- 80
C+ 79
C 75
C- 70
D 69
D- 65
in col. A1 we put the grade say: C+

The formula say in D10: Lookup(A1,B1:B11,C1:C11)

best regards,

Gabor Sebo



----- Original Message -----
From: "Shhhh" <[email protected]>
Newsgroups: microsoft.public.excel
Sent: Thursday, April 15, 2010 11:52 PM
Subject: Help with an IF statement please...