Help Needed : how do i compute this?

Joined
Nov 6, 2012
Messages
1
Reaction score
0
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
 
Back
Top