Formula for Minimum/Maximum
 

Is there a formula for the following situation?

1A - 10,000 1B - AL

2A - 15,000 2b - GA

3A - 35,000 3b - SC

You have a min/max of 12,000/25,000 AL. 10,000/25,000 GA, 13,000/25,000 SC -
so you do not want the cell to pick up less than the min or more than the max
when you total this column. Is there a formula for this? If you are dealing
with different states that have different min/max can you also have it pick
up the correct min/max for a particular state? The min/max usually has a
particular effective date. Thanks,

--


--
msladona

Formula for Minimum/Maximum
 

A bit more explanation might help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LaDonna Brooks" wrote in message
...
Is there a formula for the following situation?

1A - 10,000 1B - AL

2A - 15,000 2b - GA

3A - 35,000 3b - SC

You have a min/max of 12,000/25,000 AL. 10,000/25,000 GA, 13,000/25,000
SC -
so you do not want the cell to pick up less than the min or more than the
max
when you total this column. Is there a formula for this? If you are
dealing
with different states that have different min/max can you also have it
pick
up the correct min/max for a particular state? The min/max usually has a
particular effective date. Thanks,

--


--
msladona

Formula for Minimum/Maximum
 

I would add a separate column which checks for the min/max. In the formula
you lookup the min/max for the state. Something like:
=min(max(a2,vlookup(a4,table,2,false)),vlookup(a4, table,3,false))

Now total this column.

Regards, Fred.

"LaDonna Brooks" wrote in message
...
Is there a formula for the following situation?

1A - 10,000 1B - AL

2A - 15,000 2b - GA

3A - 35,000 3b - SC

You have a min/max of 12,000/25,000 AL. 10,000/25,000 GA, 13,000/25,000
SC -
so you do not want the cell to pick up less than the min or more than the
max
when you total this column. Is there a formula for this? If you are
dealing
with different states that have different min/max can you also have it
pick
up the correct min/max for a particular state? The min/max usually has a
particular effective date. Thanks,

--


--
msladona