Re: Formula To Calculate Sales Commission
Welcome to OzGrid!!
A couple of quick questions:
- The 5% commission is determined by?
- The 20% commission is determined by?
- What do you want the layout to be?
- Is this homework?
Obviously to calculate the commission you do a multiplication. This can be done in one or two columns. The single column method, you multiply by 1 + the commission %. The two column method you multiply by the commission % in one column and in the other, add the basis of the commission to the commission amount.
Labels, formatting, etc are other considerations for you to consider.