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