Drop-down choice affects another Cell

Hello,

Hopefully I explain my problem clearly.

I am trying to create a job estimate calculator on excel. I have different options people can input and it gives them a total price for the job. The problem I have is in the calculator there are some drop-down choices and I need the each different choices to affect the total price.

For example, if one the of the drop-down choices were "weekly" "every two weeks" or "monthly" I would need each choice to add or subtract a certain amount to the total price.

Any help would be appreciated. Thanks

Here's the worksheet. So you can plug in any number for bed/bath and it affects the total. Now I need the drop down choices to affect the total. For example, bi-weekly adds $15, monthly adds $30

Tried to plug in that formula. It just makes the total say true or false

oh i see i was added your formula with my formula that was the problem. but this works great thank you!