option buttons and array functions

[BittenApple]

Hello team,

Can we use option buttons to insert two different array functions on one set of data(table)?

Regards,
bittenapple

[HansV]

If you add two option buttons from Form Controls to the sheet, and assign a Cell link to them in the Control tab of the Format Control dialog, the value of the linked cell will be 1 when the first option button is selected, and 2 when the second option button is selected.
You can use the value of the linked cell in a formula:

=IF(A1=1, thisformula, thatformula)

S0697.png

[BittenApple]

Hello Hans,
I am grateful to your response.

I wonder if I can use the value of cell links to create two dropdowns based on the option values in cell links.

Regards,
Bittenapple

[HansV]

You can use the value associated with an option button the same way you can use the value of a drop-down.

[BittenApple]

Hello Hans,
Can I use the value of option button to create dropdowns?
Respectfully,
Bitten

[HansV]

I'm afraid I don't understand that question,

[BittenApple]

Hello Hans,
Let me work with my data, then probably I will be able to articulate it more precisely.
Respectfully,
tiba