| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box value
Hi, I would use radio buttons, you can group them together by putting a group box around them and each button within a group has it's own value and is linked to the same cell. Reserve a column to link to...say A, then to pull the value amount corresponding to the radio button selected with: =LOOKUP(A1,{1,2},{5,10}) {1,2} are the button values {5,10} are the corresponding values...in your case $5 and 10$ Note. you can not use $ in that formula. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=498123 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entry into check box dependent on other check box. | Excel Worksheet Functions | |||
| Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
| check boxes - copy | Excel Discussion (Misc queries) | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Threaded Mode
