How do you calculate in Excel commission of 7 percent on all sales that are at least 25 percent above cost?
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )