Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Option button
I have a spreadsheet with one cell I want to deplay the price from one of two
spots. How do I setup an option button so that if one is selected the price next to that button get put in my deplay cell? -- We all need a little help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Option button
First, make sure your option buttons are linked to a cell somewhere (under
format contol), for example C1. Assuming list of choices is in B1:B2, Then your formula will be =INDEX(B1:B2,C1) -- Best Regards, Luke M "Pat Rice" wrote: I have a spreadsheet with one cell I want to deplay the price from one of two spots. How do I setup an option button so that if one is selected the price next to that button get put in my deplay cell? -- We all need a little help |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Option button
How do I link the cell? I should say I have never done this before so you
should write this like I am new to excel. A1 should show the number in B1 if the option button next to it is selected or show the C1 if the option button next it is selected. I have no clue where to even start putting the formula you gave me. This is an excel form that is printed out and handed to AP to generate payroll. -- We all need a little help "Luke M" wrote: First, make sure your option buttons are linked to a cell somewhere (under format contol), for example C1. Assuming list of choices is in B1:B2, Then your formula will be =INDEX(B1:B2,C1) -- Best Regards, Luke M "Pat Rice" wrote: I have a spreadsheet with one cell I want to deplay the price from one of two spots. How do I setup an option button so that if one is selected the price next to that button get put in my deplay cell? -- We all need a little help |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Option button
Right click on one of your option buttons, then choose "format control".
Under the control tab, you'll see the cell link box. Make this go to whatever cell you want. (I'll use E1, which needs to be entered as $E$1). You could hide this cell if you want, since you're printing the form. This cell will then change in value between 1 or 2 depending on which button you select. In cell A1, enter this formula: =INDEX(B1:C1,E1) Hope that clears things up for you. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pat Rice" wrote: How do I link the cell? I should say I have never done this before so you should write this like I am new to excel. A1 should show the number in B1 if the option button next to it is selected or show the C1 if the option button next it is selected. I have no clue where to even start putting the formula you gave me. This is an excel form that is printed out and handed to AP to generate payroll. -- We all need a little help "Luke M" wrote: First, make sure your option buttons are linked to a cell somewhere (under format contol), for example C1. Assuming list of choices is in B1:B2, Then your formula will be =INDEX(B1:B2,C1) -- Best Regards, Luke M "Pat Rice" wrote: I have a spreadsheet with one cell I want to deplay the price from one of two spots. How do I setup an option button so that if one is selected the price next to that button get put in my deplay cell? -- We all need a little help |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Option button
Luke,
thank you ever so much, it worked, i had to do some tweeking to my spreadsheet because the two values were not near each other and it kept giving me problems. Now I need to figure out how to keep it from showing Value until a cell is selected. -- We all need a little help "Luke M" wrote: Right click on one of your option buttons, then choose "format control". Under the control tab, you'll see the cell link box. Make this go to whatever cell you want. (I'll use E1, which needs to be entered as $E$1). You could hide this cell if you want, since you're printing the form. This cell will then change in value between 1 or 2 depending on which button you select. In cell A1, enter this formula: =INDEX(B1:C1,E1) Hope that clears things up for you. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pat Rice" wrote: How do I link the cell? I should say I have never done this before so you should write this like I am new to excel. A1 should show the number in B1 if the option button next to it is selected or show the C1 if the option button next it is selected. I have no clue where to even start putting the formula you gave me. This is an excel form that is printed out and handed to AP to generate payroll. -- We all need a little help "Luke M" wrote: First, make sure your option buttons are linked to a cell somewhere (under format contol), for example C1. Assuming list of choices is in B1:B2, Then your formula will be =INDEX(B1:B2,C1) -- Best Regards, Luke M "Pat Rice" wrote: I have a spreadsheet with one cell I want to deplay the price from one of two spots. How do I setup an option button so that if one is selected the price next to that button get put in my deplay cell? -- We all need a little help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Button | Excel Discussion (Misc queries) | |||
Option Button | New Users to Excel | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button Help | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) |