Formula based upon the value in a specific field

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I'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?
Photo of Report Hudson

Report Hudson

  • 110 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
no problem
IF(
[Field X] = "Value 1"
or
[Field X] = "Value 2"
or
[Field X] = "Value 3"
or
[Field X] = "Value 4"
or
[Field X] = "Value 5"
or
[Field X] = "Value 6", [Field Y] * [Field Z],0)
Photo of Report Hudson

Report Hudson

  • 110 Points 100 badge 2x thumb
Thanks again for your help.  Formula was a success!