Hello team,
Can we use option buttons to insert two different array functions on one set of data(table)?
Regards,
bittenapple
option buttons and array functions
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: option buttons and array functions
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)
You can use the value of the linked cell in a formula:
=IF(A1=1, thisformula, thatformula)
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: option buttons and array functions
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
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
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: option buttons and array functions
You can use the value associated with an option button the same way you can use the value of a drop-down.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: option buttons and array functions
Hello Hans,
Can I use the value of option button to create dropdowns?
Respectfully,
Bitten
Can I use the value of option button to create dropdowns?
Respectfully,
Bitten
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: option buttons and array functions
I'm afraid I don't understand that question,
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: option buttons and array functions
Hello Hans,
Let me work with my data, then probably I will be able to articulate it more precisely.
Respectfully,
tiba
Let me work with my data, then probably I will be able to articulate it more precisely.
Respectfully,
tiba