Being Stupid - Help needed with nested IF statements

  • Thread starter Thread starter ramk1h
  • Start date Start date
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
 
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,))))))
 
You should store the formula in cell D11 but omit 'D11='
(all occurrences) from the formula
 
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:
Click to expand...
=IF(C11="A",D11=5,IF(C11="B",D11=4,IF(C11="C",D11=3,IF(C11="D",D11=2,IF
(C11=
Click to expand...
 
Back
Top