I have a spreadsheet that I need to input a $ amount, and need to calculate the monthly amount based on whatever is input. The amounts being calculated are weekly, monthly, bi-annually, and yearly and would each need their own calculation to come up with a monthly amount (the monthly amount would remain the same as input).
The fixed expense $ amount is entered in column D with the dropdown options in Column E, and final total in Column F of one sheet and the dropdown list/table (weekly, monthly, bi-annually, yearly) are on another sheet in column O. I have the dropdown working and I know how to write a formula to add a range of cells on different sheets, but I am stuck at how to write a formula that runs a calculation based on the option selected from the dropdown list.
At this moment, this is the code that I have:
=SUM('Audit'!O20:P23) * VLOOKUP(E5, 'Parameters'!O20:P23, 2)