S

#### Shhhh

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!