Commissions Calculations

[angus]

I am new to this forum.

Please help me come up with a formula to calculate the following:

6% On Last Yrs + 12% on Gross
3% On Last Yrs less Cancel
6% Last Yrs with no Gross, New Bus, Cancel
12% On New Bus.

See spreadsheet attached.

AS

[Bootroots]

Angus, I am not 100% sure I understand the formula you are asking for. If I read it correctly there are 4 factors for the total commision on any one account? If so that is the formula I used in column D off to the right of the criteria on your spreadsheet. You will need to copy and paste to the correct column and update the cell references...

as to leaving a cell balnk as opposed to 0 that is

=if({formula}=0,"",{formula})

Hope I helped.