K kazanami Joined Nov 6, 2012 Messages 1 Reaction score 0 Nov 6, 2012 #1 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
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