1 min readfrom 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.

submitted by /u/swidgen504
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article