IF Formula

[glerwell]

Hi

I want to create a formula for the following conditions:

IF K11 is "NO" then 1 is displayed
IF K11 is "1" then 2 is displayed
IF K11 is "2" then 3 is displayed
IF K11 is "3" then 4 is displayed

I've tried myself but it only works if "NO" is K11, if 1-3 in K11 then the 0 is returned.

Thanks

 

[facethegod]

Is this what you need

=LOOKUP(A11,{"1","2","3","NO"},{2,3,4,1})

 

[glerwell]

that returns N/A for anything 2,3,4 is in K11

 

[glerwell]

If I change 1,2,3 to ONE, TWO, THREE I can use the following formula:

=IF(K11="NO",1,0)+IF(K11="TWO",2,0)+IF(K11="THREE",3,0)+IF(K11="FOUR",4,0)

but I owuld prefer to be able to use 1,2,3.

 

[VoG]

Are the "1", "2" and "3" in K11 actually numbers, not text? If so you need to lose the "s in the formulas.

 

[glerwell]

VoG II - thats was problem and I've now sorted it.

facethegod - thanks for the formula.

cheers guys

 

[lenze]

=IF(K11="NO",1,Choose(K11,2,3,4,))

lenze

 

[Seti]

Maybe this?

=IF(K11="NO",1,K11+1)

assuming K11 can only be NO, 1, 2 or 3