SOLVED

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)
Solution

@MichCrot 

In J3:

 

=IF(G3="","",E3*INDEX({52,12,1},MATCH(G3,{"Weekly","Monthly","Yearly"},0)))

 

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!