Drop Down

[ehsas69]

I need help on creating a drop down list

I have following rates

1
2
3
4
5
I want a drowp down that where user can select only one of those rates.

If user select rate 1 then celles formulated in D2 should be calculated on this rate.

Thanks

 

[VoG]

Try a Data Validation list http://www.contextures.com/xlDataVal01.html