Discussions

Expand all | Collapse all

Formula based upon the value in a specific field

  • 1.  Formula based upon the value in a specific field

    Posted 06-29-2017 19:11
    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?


  • 2.  RE: Formula based upon the value in a specific field

    Posted 06-29-2017 19:18
    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)


  • 3.  RE: Formula based upon the value in a specific field

    Posted 06-30-2017 02:54
    Thanks again for your help.  Formula was a success!