Nesting a CHOOSE Statment with an IF Statement

[Zero85]

Hello, I'm having trouble correctly combining two Excel functions into one string.

My Choose Function is operating correctly. I would like my formula to read: Choose(2010,2011,2012),IF(1=S, make it S, if not make it 0).

Any help is greatly appreciated.

CHOOSE Function:

2010	1.1111%
2011	2.2222%
2012	3.3333%

<colgroup><col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 3896;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 2872;"> <tbody> </tbody>

IF Statement:

1	S
2	N
3	Q

<colgroup><col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 3896;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 2872;"> <tbody> </tbody>

 

[Gerald Higgins]

Can you post your actual CHOOSE function please, and comment on how you want to change it ?

I haven't used CHOOSE very often, and looking at Excel help, it looks like it can't literally be =CHOOSE(2010,2011,2012...)

 

[Zero85]

Sure, my Choose function is following an numbered input switch. When I select 1(Cell B23), it reflects the value 1.111%(Cell E25), when on 2, it reflects 2.222%(Cell E26). My exact formula is: =Choose(B23,E25,E26)


I want to include an IF Statement within my CHOOSE string, which would read, IF Cell G=1, make it N. IF Cell G=2, make it 0. IF Cell G=3, do nothing.

 

[Scott Huish]

But you are asking to return 2 separate values. Which one do you want or how do you want the output combined?

 

[shift-del]

Zero85,

that would be a separate formula and not nested.

=CHOOSE(G10;"N";0;"")

 

[Zero85]

But you are asking to return 2 separate values. Which one do you want or how do you want the output combined?

Yes, I'll have to switch. One to activate the Choose function, and another to activate the IF Statement function. So I want the Choose function to be the master determinant, but if the IF Statement switch is activate, it takes over the control over Choose returns. So if the IF Statement says to make the value 0, the answer would reflect that. If the IF statement says do nothing, then the CHOOSE function is in control.

 

[Zero85]

So this is the formula I currently have.
=CHOOSE($B$23,$F$36,$F$37),IF($C$6=2,0%,"")

The Choose function is working well, but my IF statement is wrong. Its showing #Value as the answer when I include an IF Statement to that strong.


Basically I wrote the IF statement to say IF cell 6 equals 2, make it 0%, if it doesn't, do nothing. (I want the choose statement to be the determinant in this case).

 

[shift-del]

Zero85,

that would be:

[COLOR=#333333]=[/COLOR][COLOR=#333333]IF($C$6=2,0%,[/COLOR][COLOR=#333333]CHOOSE($B$23,$F$36,$F$37))[/COLOR]

 

[Zero85]

Zero85,

that would be:

[COLOR=#333333]=[/COLOR][COLOR=#333333]IF($C$6=2,0%,[/COLOR][COLOR=#333333]CHOOSE($B$23,$F$36,$F$37))[/COLOR]

You got it, thank you!!

 

[FDibbins]

So this is the formula I currently have.
=CHOOSE($B$23,$F$36,$F$37),IF($C$6=2,0%,"")

The Choose function is working well, but my IF statement is wrong. Its showing #Value as the answer when I include an IF Statement to that strong.


Basically I wrote the IF statement to say IF cell 6 equals 2, make it 0%, if it doesn't, do nothing. (I want the choose statement to be the determinant in this case).

Sounds to my like you need to put the CHOOSE inside the IF, maybe as the last argument?

So if the IF Statement says to make the value 0, the answer would reflect that. If the IF statement says do nothing, then the CHOOSE function is in control.

That tyhen would be something like...
=if(G1=1,"N",1,if(G1=0,choose(...),""))

IF Cell G=1, make it N. IF Cell G=2, make it 0. IF Cell G=3, do nothing.