Formula for Minimum/Maximum

[LaDonna Brooks]

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,

 

[Don Guillett]

A bit more explanation might help

 

[Fred Smith]

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.