IfSum
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
|