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. If field x <>1 than return a zero
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
