Skip to main content
Stephen Bailey (Salesforce) 님이 #Ask An Expert에 질문했습니다
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개
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2020년 3월 16일 오후 2: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))