G
Guest
Help with the following.
Example:
A1 = Renewal sale or increase value from Existing Business (5% Commissions)
A2 = New Business from New Customers (7.5% Commissions)
A3 = Reduce Sale from Existing Business (3% Commissions)
Can someone help me with a formula that will return the correct commission
value in cell A4 based on the commission structure above?
Please note that all 3 cells will never be populated at the same time. Only
1 cell A1, A2, A3) will be populated per row.
Example:
A1 = Renewal sale or increase value from Existing Business (5% Commissions)
A2 = New Business from New Customers (7.5% Commissions)
A3 = Reduce Sale from Existing Business (3% Commissions)
Can someone help me with a formula that will return the correct commission
value in cell A4 based on the commission structure above?
Please note that all 3 cells will never be populated at the same time. Only
1 cell A1, A2, A3) will be populated per row.