Condition if than statement formual

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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
Photo of Report Hudson

Report Hudson

  • 110 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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.
Photo of Report Hudson

Report Hudson

  • 110 Points 100 badge 2x thumb
Thank you so much!