Condition if than statement formual
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. I...
Forum Discussion
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.
[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.