Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=IF(hours=<36,bonus*0.5,bonus*5)
Replace hours and bonus with the relevant cell references -- Ian -- "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 |
#4
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on ifsum | Excel Worksheet Functions | |||
IFSUM | Excel Worksheet Functions | |||
ifsum | Excel Discussion (Misc queries) | |||
IFSUM with 2 condictions | Excel Discussion (Misc queries) | |||
IF(SUM) help please | Excel Worksheet Functions |