software

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: www.excelforum.com/member.php...oamp;userid=29982
View this thread: www.excelforum.com/showthread...hreadid=496785
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: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=496785
Awesome! Thanks--
KevinR
------------------------------------------------------------------------
KevinR's Profile: www.excelforum.com/member.php...oamp;userid=29982
View this thread: www.excelforum.com/showthread...hreadid=496785Extending your range, that means a quot;1quot; 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!
==============================================quot;KevinRquot; gt; wrote in
message ...
gt;
gt; I have a drop down of the numbers 5-1.
gt; If someone selects 5, I want the cell next to it to say 6%
gt; If someone selects 4, I want the cell next to it to say 4.5%
gt; as so on.
gt;
gt; Can anyone explain how to do this?
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; KevinR
gt; ------------------------------------------------------------------------
gt; KevinR's Profile:
www.excelforum.com/member.php...oamp;userid=29982
gt; View this thread: www.excelforum.com/showthread...hreadid=496785
gt;