An alternative to the [IF] formula.

**Aland2929** · 11-14-2013, 09:06 AM

I have 8 option buttons and need a formula to identify the option selected. I have attached a sample file.
Thanks in advance

**Fotis1991** · 11-14-2013, 09:17 AM

Perhaps a simple way using a helper and hidden column is this. In I3(I will be the hidden column) and copy down use this.

Formula:

Please Login or Register  to view this content.

Then in B3 this one will gives you the expected results.

Formula:

Please Login or Register  to view this content.

**Aland2929** · 11-15-2013, 08:02 AM

Thanks very much. Works perfectly. Much appreciated.

**Fotis1991** · 11-15-2013, 08:12 AM

You are welcome and thanks for the feedback.

Re: An alternative to the [IF] formula.