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

(Etwo Cargo) #1

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

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

Thanks in advance.

(Reza Raoofi) #2

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

, “DDD” , “”)

(Etwo Cargo) #3

@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.

(Reza Raoofi) #4

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) #5

@RezaRaoofi Where i need to put that formula?

(Reza Raoofi) #6

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) #7

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