SOLVED

Help with a Project

%3CLINGO-SUB%20id%3D%22lingo-sub-2142879%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20Project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142879%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20assigning%20a%20value%20to%20word.%20I%20have%20am%20occurrence%20column%20that%20uses%20the%20words%20Monthly%2C%20Yearly%2C%20and%20Weekly.%20In%20the%20yearly%20total%20column%20I%20want%20to%20multiply%20the%20cost%20column%20by%20the%20the%20occurrence%20to%20get%20the%20total.%20Example%3A%20Netflix%20%3D%20%2420.00%20per%20month.%20The%20total%20yearly%20column%20would%20say%20%24240.00.%20That%20comes%20from%20(20%24%20x%2012%20months%20in%20a%20year%3D%20240%20yearly%20total)%2C%20I%20just%20don't%20know%20how%20to%20go%20about%20doing%20that.%20I've%20attached%20an%20example%20of%20what%20my%20project%20looks%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2142879%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2143147%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20Project%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969517%22%20target%3D%22_blank%22%3E%40MichCrot%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20J3%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(G3%3D%22%22%2C%22%22%2CE3*INDEX(%7B52%2C12%2C1%7D%2CMATCH(G3%2C%7B%22Weekly%22%2C%22Monthly%22%2C%22Yearly%22%7D%2C0)))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20or%20copy%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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!