I'm dealing with a formula that is based on square feet. Such as 0-2,999 sq ft has (x) price for (x) product. I'm kind of getting lost on where to start on writing this formula. Does anyone have anything I can reference for this scenario?
5 respuestas
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi Stephen,
Would the prices be on the product? If not, the best way woudl be to have a product called Lawn service 0-2999 sq ft and another one for Lawn service 3000-4000 sq ft, each with their own price.
Otherwise, you'll need a very long formual as you'll need to list all your products. For your example:
IF(AND(ProductName="Lawn service", Square footage<3000, 100,
IF(AND(ProductName="Lawn service", Square footage<4001, 200, NULL))