# Help with an IF statement please...

S

#### 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!

L

#### Lee Li Fong

R

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

H

#### 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...