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개
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))