On Thu, 4 Sep 2008 13:40:02 -0700, WCO wrote:

I need to see if it is possible to create a formula that will look for 2
variants to pull a range of 21 prices. For example if square foot is between
24-39 and qty=1 then it would pull a price of 10.00. This formula would
include 7 different square footage possibilities, 3 different quantity
options, for a total of 21 different price possibilities.

I wasnt sure if i could put the info on another tab and have the formula
pull from there or if it was easier to create a straight formula for it. Any
ideas are greatly appreciated.

If you can mathematically describe the relationship between quantity, size and
price, you could certainly use a formula.

Or you could just set up a table and use a combination of INDEX/MATCH to do the
lookup.

You need to provide more information.
--ron