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