Formula help
I need an If formula for the following... If [field1] is equal to "CCO" then [field2]*.52 If [field1] is equal to "ASG-F" then [field2]*.20 If [field1] is equal to "ASG-K" then [field2]*.80 e...
Forum Discussion
Because you are testing the same field and there are no other conditions, you can use CASE.
Case([field1],
"CCO", [field2]*.52,
"ASG-F", [field2]*.20,
"ASG-K", [field2]* .80)
The formula above will calculate to null if the above conditions are not met. A null is different than a zero.
If you do want the result to be a zero if the conditions are not met then use
Case([field1],
"CCO", [field2]*.52,
"ASG-F", [field2]*.20,
"ASG-K", [field2]* .80,0)
Case([field1],
"CCO", [field2]*.52,
"ASG-F", [field2]*.20,
"ASG-K", [field2]* .80)
The formula above will calculate to null if the above conditions are not met. A null is different than a zero.
If you do want the result to be a zero if the conditions are not met then use
Case([field1],
"CCO", [field2]*.52,
"ASG-F", [field2]*.20,
"ASG-K", [field2]* .80,0)
Thank you so much!
Mark
Mark