Help with a Project

New Contributor

I need help assigning a value to word. I have am occurrence column that uses the words Monthly, Yearly, and Weekly. In the yearly total column I want to multiply the cost column by the the occurrence to get the total. Example: Netflix = $20.00 per month. The total yearly column would say $240.00. That comes from (20$ x 12 months in a year= 240 yearly total), I just don't know how to go about doing that. I've attached an example of what my project looks like.

2 Replies
best response confirmed by MichCrot (New Contributor)


In J3:




Fill or copy down.

How do you even go about learning that? I understand the basics of formulas, but I didn't even know where to start with trying to find support besides posted exactly what was going on. Thank you sooo much!