Sales Bonus Formula

[jkharms]

I need a formula for calculating a year-end bonus payment based on the following plan:

The total in F8 will be increased by 10% if the totals in each of any of the three possible consecutive combinations of 4 cells (i.e. A8B8, B8C8, C8D8) are positive. Zero does not qualify as positive.

If the totals in either of the two possible consecutive combinations of three cells (i.e. A8B8C8, B8C8D8) are positive, F8 will be increased by 25%.

If the totals in all four cells are positive, F8 will be increased by 50%.

 

[jkharms]

That worked great. Thank you very much for all your help...and for taking the time to explain how the formula is working.