•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)
Our take
Are you looking to enhance your childcare tracker by implementing a dynamic formula that adjusts costs based on a dropdown selection for Hourly, Daily, Weekly, or Monthly rates? You can achieve this by utilizing the SWITCH or IFS functions in your formulas, allowing for a streamlined approach without cluttering your spreadsheet. Instead of creating multiple rows for different pay types, this method will simplify your calculations and maintain clarity. Let’s explore how to integrate this dynamic solution effectively.
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]
Read on the original site
Open the publisher's page for the full experience
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