I am making a budget spreadsheet.

I would like to enter certain expenses periods, i.e. weekly, fortnightly, monthly, quarterly and yearly. I would also like a column showing total monthly and yearly costs. So far, I have created a data validation dropdown with the period frequencies. Would I use conditional formatting to do this?

So for the monthly column, could you say "if cell C1 is "weekly" then C2*52/12, if it's fortnighly, *26/12, if it's "monthly" *1, etc etc. How can you cycle through? I did this, =IF(B17:B="Quarter",C17*4) and it does work the way I want, but I have no idea how to check for the other variables. If possible, I would like to apply the formula to a whole column, referencing the rows to the left. I really appreciate any help!

  • 1
    pls share a copy of your sheet – user0 Jan 6 at 12:04

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.