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