Can I choose a function from a list based on entry in a cell?

[nouuuugat]

I’m trying to somewhat automate a conversion from whatever pay frequency is applied to a bill to monthly, to make my budget a bit easier. I’ve attached an example of what I’m talking about; there’s a dropdown to select frequency, a field to enter payment amount at that frequency, and then I want to choose the correct formula based on the frequency. C2 has the vlookup I tried, with formulas in Column F; obviously this doesn’t work, since those formulas calculate based on the cell adjacent to them, and then just the result is what the vlookup takes.

I hope I’m being clear on what I’m trying to do. Thanks!! sample.ods

[EarnestAl]

It can be a mistake to overcomplicate. Taking your desire to calculate bills as a monthly expense and to simplify the appearance for error checking it might be better to use separate columns with a final total.

Having gaps in rows is a problem for Calc , if you want to delete a payment it is better to delete the entire row so the table is contiguous. I have left the rows untouched as I presume you have a reason for the purposes of this exercise.

Try this ConvertToMonthlyPayments.ods.

The same formula is used for all cells. There is a discrepancy of one cent between the total of the new cells and your manually calculated list, this will be due to rounding. I tried formatting the reference cells as x/12 but it reverts to a compound fraction # x/12. Cheers, Al