| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting drop down to change next cell
I have a drop down of the numbers 5-1. If someone selects 5, I want the cell next to it to say 6% If someone selects 4, I want the cell next to it to say 4.5% as so on. Can anyone explain how to do this? Thanks! -- KevinR ------------------------------------------------------------------------ KevinR's Profile: http://www.excelforum.com/member.php...o&userid=29982 View this thread: http://www.excelforum.com/showthread...hreadid=496785 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting drop down to change next cell
Here's one way: For the dropdown in A1..... B1: =CHOOSE(A1,1%,2%,3%,4.5%,6%) The first argument of CHOOSE must be an integer The above example equates to: If A1 is 1, then 1% If A1 is 2, then 2% If A1 is 3, then 3% If A1 is 4, then 4.5% If A1 is 5, then 6% Post back if you have questions. Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=496785 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting drop down to change next cell
Awesome! Thanks -- KevinR ------------------------------------------------------------------------ KevinR's Profile: http://www.excelforum.com/member.php...o&userid=29982 View this thread: http://www.excelforum.com/showthread...hreadid=496785 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting drop down to change next cell
Extending your range, that means a "1" in the drop-down should return zero
.... correct? 6, 4.5, 3, 1.5, 0 So, with the drop-down in A1, Try this in B1: =LOOKUP(A1,{1,2,3,4,5;0,1.5,3,4.5,6}) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "KevinR" wrote in message ... I have a drop down of the numbers 5-1. If someone selects 5, I want the cell next to it to say 6% If someone selects 4, I want the cell next to it to say 4.5% as so on. Can anyone explain how to do this? Thanks! -- KevinR ------------------------------------------------------------------------ KevinR's Profile: http://www.excelforum.com/member.php...o&userid=29982 View this thread: http://www.excelforum.com/showthread...hreadid=496785 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the format in a excel drop box? | Excel Discussion (Misc queries) | |||
| How can one cell be autopopulated by another cell and have a drop. | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
