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