=IF(total_hours<36,sales*.5,sales*5)

--

HTH

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


"TYE" wrote in message
...
i would like 2 do the following,

if an person as done less then 36 hours all their bouns from 5 will go
down
to 0.50

=<36hours (bonus/5), this times 0.50

like a sum that works this out

e.g

Ian Smith did 34 hours got 10 sales @ 5 total = 50 so i need a sum that
will
change this so it say 5 not 50