You could just modify one of the examples in the reference page that I
gave. Your situation is a very straightforward case of the commissions
example listed there. For instance, if your commission table is:

J K L
1 Sales Marginal Rate Differential Rate
2 0 2.5% =K2
3 800000 =K2*1.25 =K3-K2
4 =J3*1.25 =K2*1.5 =K4-K3

Then, assuming Revenue Booked is in A1, the formula is simply:

=SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4),$L$2:$L$4)


In article ,
Astrid wrote:

If someone out there could help me figure out how to create my commissions
table, I would appreciate it a lot (you have no idea).