•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Dynamic formula to change calculation based on a dropdown (Hourly vs Daily vs Weekly vs Monthly)
I am trying to modify my childcare tracker with a dynamic formula that tracks the cost ($B$1250) per Hour, Day, Week, or Month from a dropdown menu in cell $C$1249.
Currently the rows 1255 and 1263 (plus many more) contain formulas such as =SUM(D1253:D1254)*$B$1250. In this hourly pay scale, I just put the number of hours I need for each day, but of course that would change based on pay type.
Is there a dynamic SWITCH or IFS formula I can use in those rows, or am I just nuking things? I know I could also add more rows Hourly, Daily, Weekly, Monthly rows and just sum them, but I figured that would become an even more excessive eyesore.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#dynamic formula
#Excel
#childcare tracker
#cost tracking
#dropdown menu
#cost per unit
#SWITCH formula
#IFS formula
#tracking cost
#hourly pay