Your formula works for the criteria you have given if H16 is greater
than 0 (True) then show 0, IF it is 0 or blank (False) then look at the
sum of F16:F17 if it is greater than or equal to C12 then SUM G16:G27
(True) if it is not greater than or equal to C12 then show 0 (False)

It's correct for each aspect, i dont understand your problem.

hcronrath;244830 Wrote:
The plan bonus should end once it equals the total growth bonus. Here is
the
formula that I use to calculate the Plan bonus:

=IF(H160,0,IF(SUM(F$16:$F17)=$C$12,(SUM($G$16:$G $27)),0))

where H16=Plan bonus, sum(f16:f17)=increase over best, C12= monthly
plan,
sum(g16:g27) =growth bonus

My data is below:
Monthly Plan $33,829
Monthly 2mo avg increase growth Plan
Sales over best bonus bonus
$7,089 $7,089 $7,089 $- $-
$16,385 $11,737 $4,648 $106.90 $-
$42,591 $29,488 $17,751 $408.27 $-
$25,636 $33,829 $4,341 $99.85 $615.03
$56,416 $33,829 $- $- $-
$5,630 $31,023 $- $- $615.03


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68283