Forum Discussion

ReportHudson's avatar
ReportHudson
Qrew Trainee
7 years ago

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...