Hi,

I'm having problems figuring out how to create what I need. Any help would be appreciated.
I'm trying to create a grid that says (for example), if the Width is 10" - 14" and the Height 20" - 36", then the price is $100.00
This continues (if the width is 14" - 18" and the height is 36" - 42", then the price is $130 etc...
The formulas need to recognize either fractions or decimals so if I were to enter 10 1/2" or 10.5 as my width, then the price would still be $100.
Does this make sense?
Is this even possible?
Thank you in advance for any help.
Jacen