Im trying to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
I cannot figure out a formula to help me do this.
I have product cost in cell a3 and retail price in b3. So i first need to figure the percentage above cost, which will be in cell d3. Then if the percentage above cost is 20% or more i need to calculate a 6% commission which will be in cell f3. I am so frustrated.
Bookmarks