It may be just me who finds that confusing, but can you give some data
example and a result walkthrough?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JOSE V via OfficeKB.com" wrote in message
...
Need a formula for this: Going crazy!
First come up with a cell stating (number 400) and reference it in the
calculation.
5 sellers
a bonus calculated as follows;
$20 for each boat over 150
an additional 20% of this amount (units over 150 X $20)added to amount of
years (10) the person has been a seller.