Forum Discussion
Trouble with <>= in formula
I have been trying to put together a formula to calculate commissions that are on a tier that increases based on adding previous months gross margin to current months gross margin. We have 5 differe...
Change the first column of your gross margin table to these values (numbers!):
0
20,000
40,000
60,000
80,000
Then use a formula like this one (assuming your amount is in cell E3) to fetch the rate:
=XLOOKUP(E3,$A$2:$A$6,$B$2:$B$6,,-1)