ContributionsMost RecentMost LikesSolutionsRe: Formula based upon the value in a specific fieldThanks again for your help. Formula was a success!Formula based upon the value in a specific fieldI'm looking to create a formula where it looks to a field X to see if it contains one of six values, if one of those values are in the field then look at two addition fields Y and Z and then multiply them together, if one of the six values are not in field X, return a value of 0. Is it possible to validate for six values and then perform an additional function?Re: Condition if than statement formualThank you so much!Condition if than statement formualI 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