Skip to main content
Question

Formula help

  • June 28, 2018
  • 0 replies
  • 17 views
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 
else [field2] is 0 or blank

Sorry but I am terrible at figuring out formula structures :-(
    This topic has been closed for replies.

    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)
    Terms & ConditionsAccessibility statement