how do i compute the commission for the amount $31,800 based on : "Amount above $10000, the 1st $5000 is 1%, the next $5000 is 1.5% and the balance will get a commission of 2%." and using either of these functions Sumif, If and And, Vlookup
Help Needed : how do i compute this?
- Thread starter kazanami
- Start date