•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Tiered Results Formula with Multiple Outcomes
I know the basics but I'm a lil stumped on a formula to use for this specific situation. I have to build payroll spreadsheets for every employee based on their pay plans. Some of their plans were changed where they get a larger percentages based on the gross total for that month.
To keep it simple, how would I build something to give a different percent based on the total in one cell. Just to keep it simple for this example.
0-100 pays 1%
101-300 pays 1.25%
300+ pays 1.5%
I've done similar IF formulas but never quite exactly like this situation. I appreciate the help, as I'm still just learning and couldn't find an exact answer from Google based on how I was trying to phrase it.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#natural language processing for spreadsheets
#Excel alternatives for data analysis
#generative AI for data analysis
#cloud-based spreadsheet applications
#AI formula generation techniques
#rows.com
#financial modeling with spreadsheets
#formula generator
#big data management in spreadsheets
#machine learning in spreadsheet applications
#AI-native spreadsheets
#Excel compatibility
#google sheets
#predictive analytics in spreadsheets
#cloud-native spreadsheets
#Excel alternatives
#payroll
#formula
#pay plans
#spreadsheets