OR function

[rwanekr]

Need some help with the OR function. What I would like to do is to take mulitple input fields and see if they are compariable to either "CAB1" or "CAB2", if so, "CABINET" will be the output or it will be "FAK" if it is not. I had a nested IF(LOOKUP( statements, but that didn't work so I am trying to figure out the OR function.

 

[ekimr]

Off the top of my head and just passing through again - have you thought about the MEMBER function?

Mike

 

[janhes]

if you want to use IF
IF(value = "CAB1" | value = "CAB2","CABINET","FAK&quot
or
IF(MEMBER(value1,{"CAB1","CAB2"}),"CABINET","FAK&quot