Forum Discussion
Need help with formula
Hi community, I could realLy use a hand with a formula, E3 IS THE PROFIT PERCENT FOR SPECIFIC JOB, THE SLIDING SCALE IS: 0-20% HE GETS 1% OF TOTAL PROFIT DOLLARS 21-30% HE GETS 2% OF TOTAL PR...
Create a small lookup table:
The reward percentage is
=XLOOKUP(E3,$L$2:$L$6,$M$2:$M$6,"",1)
With the total profit in F3, the reward amount is
=F3*G3
See the attached demo.
(P.S. Please turn off your Caps Lock key)