Feb 17 2021 05:35 AM
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.
Feb 17 2021 06:46 AM
SolutionIn J3:
=IF(G3="","",E3*INDEX({52,12,1},MATCH(G3,{"Weekly","Monthly","Yearly"},0)))
Fill or copy down.
Feb 17 2021 06:50 AM
Feb 17 2021 06:46 AM
SolutionIn J3:
=IF(G3="","",E3*INDEX({52,12,1},MATCH(G3,{"Weekly","Monthly","Yearly"},0)))
Fill or copy down.