Working with Values from Combo Box / Drop Downs

I am doing a budget planner where the user selects from a dropdown list the frequency of outgoing. So say a gas needs to be paid every 2 months the user will select this option and the in the cell next to it, key in the amount. How can I gather all this data and get say a weekly amount required based on all weekly, fortnight, monthly, yearly values

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.