CodyBBall05
New Member
- Joined
- May 25, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello i am trying to create a spreadsheet that shows my bonus on my commission pay plan. but i am running into the issue of trying to create the formula for all of the specific numbers that are need
for example if l6 is greater than 90% and m6 is greater than 140% then n6 equals 4.50. this is the easy part, but it gets tricky when EX:
l6 is greater than 85% but less than 89.99% and m6 is greater than 135% but less than 139.99% then n6 equals 4.00
and it goes down the list in the percentage numbers both dropping in increments of 5 and the bonus number dropping in increments of .50
any help on this at all would be much appreciated!!!!
for example if l6 is greater than 90% and m6 is greater than 140% then n6 equals 4.50. this is the easy part, but it gets tricky when EX:
l6 is greater than 85% but less than 89.99% and m6 is greater than 135% but less than 139.99% then n6 equals 4.00
and it goes down the list in the percentage numbers both dropping in increments of 5 and the bonus number dropping in increments of .50
any help on this at all would be much appreciated!!!!