Hi folks, need a quick answer if possible.
I have a several commission rates denoted in cells
I want, in another cell that shows each persons aggregate sales, to calculate their commission based on those rates.
So, if they sold 1755 they get 2.5%
Can I do this all in one IF formula?
So in each row, I have a Total Number sold (H8), a selling rate (I8), an amount (H8*I8).
The commision Cell needs to test the Total (H8) and reference the Commision rates (Cells C2 to C5) then multiply to get the Persons commisson.
I hope that makes sense!