Change cell value based on drop down menu

[cbc818]

Hello Everyone,

So I created a drop down menu with the days of the week on it. Now I want to be able to alter a cells data to read a time per each day.

=IF(K21="Friday","4:00pm")
This formula works and hypothetically I should just be able to repeat this a bunch of times but for some reason Excel doesn't like me and refuses to obey when I do this:

=IF(K21="Friday","4:00pm"),IF(K21="Saturday","3:00pm"),IF(K21="Sunday","2:00pm"),IF(K21="Monday","4:00pm"),IF(K21="Tuesday","4:00pm"),IF(K21="Wednesday","4:00pm"),IF(K21="Thursday","4:00pm")

Anyone have an ideas?

 

[rbnaik]

Please use this:
=IF(K21="Friday","4:00pm",IF(K21="Saturday","3:00pm",IF(K21="Sunday","2:00pm",IF(K21="Monday","4:00pm",IF(K21="Tuesday","4:00pm",IF(K21="Wednesday","4:00pm","4:00pm"))))))

 

[cbc818]

Perfect! Thanks so much! What was I doing wrong in mine?

 

[rbnaik]

The last one result will be shown if earlier criteria are not met