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!
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!
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
Awesome! Thanks
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks