Useing an If Statement with the data validation function (drop down list)

[THKUCOMEAGAIN]

ok i am doing a final exam spreed sheet for my school and i need to use an If statement with the data validation function (drop down list) here's what i got so far

=IF(L2="poor",1*L15,""=IF(L2="Normal",L15*2,=if(L2="Awsome", L15*3,0)))

where as "poor", "Normal", "Awsome" are the option in the drop down box

This function works for the first option if i dont nest any other ifstatements into it but i kinda need that lol so plz help

 

[VoG]

Try

=IF(L2="poor",L15,IF(L2="Normal",L15*2,IF(L2="Awsome", L15*3,0)))

 

[Gerald Higgins]

To make it super super awesome, try

=IF(L2="poor",L15,IF(L2="Normal",L15*2,IF(L2="Awesome", L15*3,0)))

 

[THKUCOMEAGAIN]

Thank you very much it worked, but i was just wondering why your formula worked and mine didn't. I looked at my code and your's and its almost the exact same. Just you didn't multiply L15 by 1 ("poor") why is that ?

 

[THKUCOMEAGAIN]

Apon futher revision i relized that i has some "" where they weren't supposed to be and tyvm again