Skip to main content
Hello,

 

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 risposte
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    16 mar 2020, 14:44
    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))