If Formula
 

I can not find the correct formula for the following scenario:

Cell "a" has a number in it. I need cell "c" to show a set default number
if the number is column "a" is greater than the set number and for it to show
the exact number is column "a" if the value is less than the set number.

IE: cell a = 5,868 cell c to show 5,868 since it is less than 11,000
--
Shelly

If Formula
 

=IF(A1<C1,A1,C1)

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Shelly" wrote:

I can not find the correct formula for the following scenario:

Cell "a" has a number in it. I need cell "c" to show a set default number
if the number is column "a" is greater than the set number and for it to show
the exact number is column "a" if the value is less than the set number.

IE: cell a = 5,868 cell c to show 5,868 since it is less than 11,000
--
Shelly

If Formula
 

If you want the formula to be in Cell "c" then it can't also have the
default value unless it is hard coded into the formula:

=MIN(A1,11000)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Shelly" wrote in message
...
I can not find the correct formula for the following scenario:

Cell "a" has a number in it. I need cell "c" to show a set default number
if the number is column "a" is greater than the set number and for it to
show
the exact number is column "a" if the value is less than the set number.

IE: cell a = 5,868 cell c to show 5,868 since it is less than 11,000
--
Shelly

If Formula
 

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?
--
Shelly


"Dave F" wrote:

=IF(A1<C1,A1,C1)

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Shelly" wrote:

I can not find the correct formula for the following scenario:

Cell "a" has a number in it. I need cell "c" to show a set default number
if the number is column "a" is greater than the set number and for it to show
the exact number is column "a" if the value is less than the set number.

IE: cell a = 5,868 cell c to show 5,868 since it is less than 11,000
--
Shelly

If Formula
 

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?

If Formula
 

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?