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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com