Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing Apples and Oranges
I just cant seem to get my arms around this. Heres the scenario.
For a bunch of consultants, Im calculating State Unemployment Tax (on a weekly basis, which I can call a period basis). The calculation is as such: =IF(H5="NY",MIN(554.62,(L5*0.06525)),IF(H5="NJ",MI N(274.73,(L5*0.00925)),IF(H5="CT",MIN(285,(L5*0.01 9)),0))) This is then filled down. Im also calculating Federal Unemployment Tax (on a period basis). This calculation is as such: =MIN(56,(0.008*AF5)) This is then filled down. .. . . And now for the oranges For consultants, Im doing a running sum, as such: =SUMIF($G$5:G5,G5,$L$5:L5) This is then filled down. I need to do this to get the total paid to a consultant to see if the amount exceeds $106,800 which is the cap for Social Security Tax. If I did the per-period calculation for the SS Tax, Id NEVER hit the $106,800 threshold. Medicare is calculated on a period basis, as such: =MIN(U5*0.062,6621.6) This is then filled down. Now as Im subtracting these taxes from the Gross Income, per consultant, as such: =(N5-S5-T5-V5-W5-L5)*D5 This is then filled down. Each consultant may work for a few different firms per year and they may work for several months, and then not work for a couple weeks, and then work for several more months. This is why the consulting firm wants to see its profit per consultant, per period. As Im trying to find the consulting firms profit per consultant, its running into a major problem because the running sum is constantly increasing (to get to that $106,800 number) but the other calculations are all per period (basically one row)!! I must be looking at this the wrong way; shouldnt be so hard. I inherited this spreadsheet from someone who doesnt know much about Excel and now Im trying to straighten out there problems. Can someone here think of a better way to do what I need to do? Thanks! Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to sum two conditions like apples of Grade "B" | Excel Programming | |||
can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green") | Excel Worksheet Functions | |||
Comparing | Excel Programming | |||
Who buys the apples | Excel Discussion (Misc queries) | |||
Apples or pears | Excel Programming |