Need additional help

[Guest]

Yesterday I posted this question and got 2 EXCELLENT replies but when I used
it I realized that I missed something in my question so I need to re-ask the
questu=ion with the additional info

my original question was "if 7000-c2-e2-g2 less then zero put zero in column
& if 7000-c2-e2-g2 is greater then zero put the actual sum in column

I need to have both in one column

Now that I tested the formula I realize that instead of the actual number
being the result of 7000-c2-e2-g2 I need to it be if less then 7000 enter the
number in column g2 and additonal if greater then 7000 enter only 7000. Is
this possible. I want to use this in a worksheet I use to figure the futa
tax - I have alot of employees so it would be great if I didn't have to
figure them all out manually and let excel do it - normally I end up
overwriting the formula's with the number I need to appear. Hope this makes
sense

 

[Guest]

=IF(A1<7000,G2,7000)

Assumes the value you're checking is in A1. Adjust to suit your needs.

Dave

 

[Guest]

my formula right now reads =if(7000-(c27+d27+e27)<0,0,7000-(c27+d27+e27))

column c represents 1st qtr wages
column d represents 2nd qtr wages
column e represents 3rd qtr wages

so if 7000- c+d+e is less then zero it inputs zero
but if 7000-c+d+e is greater then zero I need it to input the number in
column (in this case) column e
You see the cut of is 7000 once an employee hits that max the tax stops but
untill they hit that you pay tax on the amount made in that qtr unless it
exceeds 7000 or if for instance they made 2000 in column c 4000 in column d
and 3000 in column e - the tax would then based on 1000 dollars
(2000+4000+3000 is 9000 so 2000 of the 3000 is in excess of the total 7000
for the year in that case I would want it to say 1000 -

I am not sure this is even possible to do in a formula all contained in the
same column - Thanks for any help

 

[Guest]

Hi pamela,
Try this...
=IF((C2+D2+E2)<=7000,0,(C2+D2+E2)-7000)

 

[Guest]

I think I mis-interpreted your question. Are you saying the employees pay
taxes only on the first $7000, but they have to pay them in the Qtr earned?
Example... Dave earns $4000 in Qtr1, Pays taxes on $4000 - earns $2000 in Qtr
2, pays taxes on $2000 - earns $3000 in Qtr 3, pays taxes on $1000 - earns
$2000 in Qtr 4, pays no tax.

 

[Guest]

That is it in a nut shell

this is the formula I have right now -

=if(7000-(c27+d27+e27)<0,0,(or(7000-c27+d27+e27)<7000,E27,(or(7000-c27+d27+e27)>7000,7000,)))))

it works fine for when it needs to say zero just doesn't work the rest of
the way - it says True or false

TRUE


Thanks for your help

 

[Guest]

I think there a couple of ways to go about it...
(1) If you input the quarterly incomes in col's C, D, E, & F and want to
show the taxable amount for the current quarter in col G, you will have to
have a cell where you input a date, and then use an IF(AND) function to look
at the date and the amount in each quarter.
(2) If you input the quarterly incomes in col's C, D, E, & F and can show
the taxable amount for each quarter in col's G, H, I, & J, the formula's will
be a lot easier. I can play with it some more tomorrow. Let me know which way
you want to go. Sometimes IF functions can be a pretty good challange.