Discussions

Expand all | Collapse all

Condition if than statement formual

  • 1.  Condition if than statement formual

    Posted 06-28-2017 14:57
    I looking to build a formula that will do the following:

    If field x = 1 than look at field y, if the numerical value is less than 40 return zero, 40 to 150 return .5 and 150 or above return a 1.  If field x <>1 than return a zero


  • 2.  RE: Condition if than statement formual

    Posted 06-28-2017 15:09
    If(
    [field x]=0,0,
    [field x] = 1 and [field y]<40,0,
    [field x] = 1 and [field y]<=150,0.5,
    [field x] = 1 and [field y]>150,1)

    // you will need to check your "fence posts" for what happens at exactly 150.


  • 3.  RE: Condition if than statement formual

    Posted 06-28-2017 16:25
    Thank you so much!