Jan 17, 2022 12:46 PM
I need help building a nested IF formula with ORs that implements the following logic: If {Field A} = ValueA OR ValueB then return contents of {Field X}, If {Field A} = ValueC, then return contents of {Field Y}, if {Field A} = ValueD OR ValueE, then return contents of {Field Z}. Thanks!
Jan 17, 2022 01:21 PM
Hi @Jenny_Pitman,
Since all of your conditions hinge on the value of one field, I’d suggest using the SWITCH()
function. It requires a little bit of repetition of return values, but makes the formula itself much more intelligible when you want to go modify it or add new logic to it later.
SWITCH(
{Field A},
ValueA, {Field X},
ValueB, {Field X},
ValueC, {Field Y},
ValueD, {Field Z},
ValueE, {Field Z}
)
Jan 18, 2022 04:33 AM
Thanks very much, Jeremy. Very helpful! Best regards, Jenny Pitman