TYE Wrote:
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
It appears that your example (last sentence) is not consistent with
your premise. Anyway, I am suggesting a solution based on how I
interpret your last sentence. Based on this, your IF statement would
look something like this:
IF[/b] (HOURS_WORKED<36) *THEN* (BONUS=5)* ELSE * (BONUS=SALES*5)
AND SO, YOUR FORMULA SHOULD BE
[b]=IF(B1<36,5,C1*5)
where
B1 contains the number of hours worked and
C1 contains the sales
... hope this is what you need.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=399735