help with formula reqiured,

Hi really need some help with a formula

Have a List Cell L6 1-5

and need to apply a calcualtion to cell Y36 which allready has a Sum ( addition of 9 Cells )
I need to apply a Formula to Y36 depenant of what is selected in L6
if 1 is selected then Y36 needs to be /1*5
if 2 is selected then Y36 needs to be /2*5
if 3 is selected then Y36 needs to be /3*5
if 4 is selected then Y36 needs to be /4*5
if 5 is selected then needs to be as is

Can anybody help please????

Thanks

Hi tabbitt,

Welcome to the forum.

Request you to change your thread title to some meaningful title which clearly describes the question you are asking.
See the forum rules :-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>