Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone care to tackle this??
this is the formula i came up with for stats we have to keep were i work.. the run down is that as your percentage increase there is a higher payout. Can this be made smaller? =IF(A1="French Stats",($E$10<100%)*(2.5*E6)+($E$1099.99%)*($E$10 <125%)*(3.5*E6)+($E$10124.99%)*($E$10<150%)*(4*E6 )+($E$10149.99%)*($E$10<175%)*(4.5*E6)+($E$10174 .99%)*($E$10<200%)*(4.75*E6)+($E$10199.99%)*($E$1 0<225%)*(5*E6)+($E$10224.99%)*($E$10<250%)*(5.25* E6)+($E$10249.99%)*($E$10<275%)*(5.5*E6)+($E$102 74.99%)*($E$10<300%)*(5.75*E6)+($E$10299.99%)*($E $10<325%)*(6*E6)+($E$10324.99%)*($E$10<350%)*(6.2 5*E6)+($E$10349.99%)*($E$10<375%)*(6.5*E6)+($E$10 374.99%)*($E$10<400%)*(6.75*E6)) as you can see there is a lot of between % (i.e paid this between 100-125%) -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=521162 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
day care providers | Excel Discussion (Misc queries) | |||
Best way to tackle this problem... | Excel Worksheet Functions | |||
How to tackle Division by zero for DAVERAGE function | Excel Worksheet Functions | |||
These templates are amazing! This really shows you care about us! | Excel Discussion (Misc queries) |