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

Need a formula for this: Going crazy!
First come up with a cell stating (number 400) and reference it in the
[quoted text clipped - 4 lines]
an additional 20% of this amount (units over 150 X $20)added to amount of
years (10) the person has been a seller.



NAME BOATS SOLD YEARS SERVICE
BONUS 150
ANTHONY PETRINO 140 4

JOHN PETRICK 200 2 "
ANTHONY CLARK 221 15 "
DAVID JONES 110 3
RODNEY YOUNG 109 2



IMAGINE THE COLUMNS A1 THRU A4. NAME, BOATS SOLD, YEARS OF SERVICE, AND BONUS.
NEED TO COME UP WITH THE BONUS FOR EACH ONE. REFERENCING CELL A4 (BONUS 150.)
IN THE COMPUTATION. BONUS CACULATIONS ARE $20 for each boat over 150
an additional 20% of this amount (units over 150 X $20)added to amount of
years the person has been a seller.

THANKS IN ADVANCE.


--
Message posted via http://www.officekb.com