Dear friends, Sorry to ask that. Is the formu...

[Etwo_Cargo]

Dear friends, Sorry to ask that. Is the formula right?

=IF(OR([ABC]=“1085”,[ABC]=“1087”,“DDD”,""))

Thanks in advance.

[RezaRaoofi]

There seems to be a missing closing parenthesis for OR(); this one should be correct: IF( OR([ABC]=“1085”,[ABC]=“1087”)

, “DDD” , “”)

[Etwo_Cargo]

@RezaRaoofi Dear Reza, used

=IF(OR([flight]=“1085”,[flight]=“1087”),“TGD”,""))

but error messages is

Expression ‘=IF(OR([flight]=“1085”,[flight]=“1087”),“TGD”,""))’ could not be parsed due to exception: Number of opened and closed parentheses does not match.

pasted it to app formula section and tried it in suggested value section too.

[RezaRaoofi]

Yes, I later noticed and corrected my suggested formula, but I think it was too late and you got the wrong version! My bad!

Please refresh your Google plus, or reopen this post and see the correct version with one less parenthesis in the end.

[Etwo_Cargo]

@RezaRaoofi Where i need to put that formula?

[RezaRaoofi]

I did not suggest to put the formula in a different place; I just corrected my own formula minutes after I had posted, but you got the older one with extra parenthesis.

Try this formula, it should work now:

IF(OR([flight]=“1085”,[flight]=“1087”),“TGD”,"")

[Aleksi_Alkio]

When the else value is not needed, you could write it like IFS(OR([flight]=“1085”,[flight]=“1087”),“TGD”)