Cell Formula based on drop-down result in other cell

[Zeventy128]

I am creating a Monthly budgeting spreadsheet and wish to know if there is an easy way that the values in column D are able to be calculated back to a monthly value based on the frequency value paid chosen from the drop down list in column C?

Untitled.png

Thanks.

[sandy666]

maybe this one in D2 and drag down

=CHOOSE(MATCH(C2,{"Daily","Weekly","Fortnightly","Monthly","Annualy","Adhoc"},0),B2*365/12,B2*52/12,B2*26/12,B2,B2/12,B2)

if I understood well

[Zeventy128]

Perfect! Thanks Sandy

[sandy666]

You are welcome

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

If you did it already - ignore it.
Thank you.