Being Stupid - Help needed with nested IF statements

[ramk1h]

I am attempting to nest 6 'IF' statements with no success, code a
follows:
=IF(C11="A",D11=5,IF(C11="B",D11=4,IF(C11="C",D11=3,IF(C11="D",D11=2,IF(C11="E",D11=1,IF(C11="F",D11=0,))))))

Any pointers as to my mistake would be greatly appreciated

 

[Andy B]

Hi

In D11 try:

=IF(C11="A",5,IF(C11="B",4,IF(C11="C",3,IF(C11="D",2,IF(C11="E",1,IF(C11="F"
,0,))))))

 

[Geoff Goodacre]

You should store the formula in cell D11 but omit 'D11='
(all occurrences) from the formula

 

[Frank Kabel]

Hi
you may also consider using a lookup table and VLOOKUP to get your
matching values. Or for your specific case you may also use the
following formula:
=70-CODE(C11)

--
Regards
Frank Kabel
Frankfurt, Germany

Hi

In D11 try:

=IF(C11="A",5,IF(C11="B",4,IF(C11="C",3,IF(C11="D",2,IF(C11="E",1,IF(C1
1="F"
,0,))))))


--
Andy.

I am attempting to nest 6 'IF' statements with no success, code as
follows:

=IF(C11="A",D11=5,IF(C11="B",D11=4,IF(C11="C",D11=3,IF(C11="D",D11=2,IF
(C11=

 

[ramk1h]

Thanks a lot, so obvious when it is highlighted