I'm pretty sure I'm needed to use the IF function, but to be honest I'm really not sure as I have been looking for answers on this all day and can't figure it out. I have made an example spreadsheet using Google Sheets and I have linked that below so you can go in and see exactly what I'm wanting to do.
LINK to Spreadsheet:
zTest - Personal Expenses
What I want to do...
On the Expense tab I would like to be able to select they billing period from the Billing column and then from that option calculate the monthly and yearly cost for each item added to the expense tracker.
I have the billing durations set in the List’s tab:
Yearly - 1
Quarterly - 4
Monthly - 12
Bi-Weekly - 26
Weekly - 52
Daily - 365
Work Weeks - 50
Work Days - 250
And then I have an example on the “Test Sheet” of how I would want the formulas to preform. Basically I would like it to be a selectable formal like this.
(Amount) x (Perior) = Yearly Amount
(Yearly Amount) / 12 = Monthly Amount
Any help would be super awesome, extra points if you just want to write the formal for me
Cheers
Jeremy
LINK to Spreadsheet:
zTest - Personal Expenses
What I want to do...
On the Expense tab I would like to be able to select they billing period from the Billing column and then from that option calculate the monthly and yearly cost for each item added to the expense tracker.
I have the billing durations set in the List’s tab:
Yearly - 1
Quarterly - 4
Monthly - 12
Bi-Weekly - 26
Weekly - 52
Daily - 365
Work Weeks - 50
Work Days - 250
And then I have an example on the “Test Sheet” of how I would want the formulas to preform. Basically I would like it to be a selectable formal like this.
(Amount) x (Perior) = Yearly Amount
(Yearly Amount) / 12 = Monthly Amount
Any help would be super awesome, extra points if you just want to write the formal for me
Cheers
Jeremy