•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