Formula for Minimum/Maximum

L

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,
 
F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top