Being Stupid - Help needed with nested IF statements

R

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
 
A

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,))))))
 
G

Geoff Goodacre

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

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

Andy B said:
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.


ramk1h > said:
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=
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top