Thank you - that really helped.
--
Shelly


"Gord Dibben" wrote:

In C1 enter =MAX((B1-11000),0)

In D1 enter =MIN(11000,B1)

If B1 contains <11000 you will get 0 in C1 and the amount in D1

If B1 contains 11000 you will get the difference in C1 and 11000 in D1


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 09:02:02 -0700, Shelly
wrote:

Ok - I am trying to create a table for my state withholding taxes for payroll
for our company. In column b I have the employees quarterly wages, in column
c I need it to show how much is excess wages and in column d I would like it
to figure the taxable amout which in our state goes up to $11,0000. For
example if someone had a quarterly wage of $5850.00, how do I get column d to
show that total amount because it is less than and not equal to $11,000 and
column c to show 0 because there is no excess at that time. Does this make
more sense?