"B-Cut" wrote:
I am thinking that a "MAX" command needs to be incorporated into the
formula, but I can't seem to figure out how to do it.

Perhaps because, in part, it is MIN, not MAX, that you need. See my other
response for details.


----- original message -----

"B-Cut" wrote in message
...
Thanks Don, here are two different formula's that I have tried.

=IF(I24<=7000,B24," - ") This one works, but doesn't actually stop
at
exactly 7000. It depends on close the prior YTD totals were to 7000.00
Ex:
if prior total was 6000.00, then when newest pay amount of 2000 gets,
added,
it takes him to 8000, which of course then puts the value of " - " in
that filled, but leaves the cell stop at 6000 from that point on. I need
to
figure out how to calculate the difference.

Then I tried this formula: =IF(I12<=7000,B12,IF(I127001,7000-K13))


This almost works, but the opposite thing happens. It does fill in the
difference the first time the criteria equals 7000, but then on the next
pay
period when you would add another 2000 to YTD; it subtracts the difference
between YTD and 7000. Ex; if his YTD gross is now 10,000, then it
subtracts
7000 and tries to calculate FUTA and other taxes on 3000 for that period.

I am thinking that a "MAX" command needs to be incorporated into the
formula, but I can't seem to figure out how to do it. I hope you can
help.
THANKS

Rick

p.s. I have looked in the help index for MAX, but I am not getting it.
They
show such poor examples.


"Don Guillett" wrote:

Always nice to show us your formula. Take a look in the help index for
MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"B-Cut" wrote in message
...
what is the formula required to stop employee and employer paid taxes
once
a
tax limit criteria has been met? Ex. once 7000.00 in gross wages has
been
met, you no longer have to take out FUTA.

It is easy to figure out the formula above and well below 7000.00, the
problem is that one pay period when they finally meet the 7000.00, but
it
does not know what to do with the excess amount. Example. pay period
1 -
employee gross wages are 2000. Tax formula works fine. Pay perios 2,
another 2000 in wages, now YTD total is 4000. Still fine. Pay period
3,
another 2000, everything still fine because YTD is now 6000. But now
on
pay
period 4 - another 2000, but now it jumps to 8000 YTD. But my forumula
does
not work, because he went over 7000, but it didn't know how to add just
the
1000 difference to cap the FUTA at 7000.

anyone out there that knows what the formula would be, please help.