Condition if than statement formual

Question

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

QuickBaseCoachD · Answer

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.

Sign up

Login to the community