If [OH:Subsample ID] is blank, OR if it contains "ABC", then the calculated field should return result "XYZ".

No idea how to put that into syntax.

I can get two separate lines, but can't get them combined into one command line:

=IF([OH:Subsample ID]"Header Line","Audit")

=IF(ISBLANK([OH:Subsample ID]),"Audit")
  • Do you want the exact match of "ABC" or the field value contains substring "ABC" inside it's value? – Ganesh Sanap Sep 14 '19 at 4:31

The syntax for using OR is as follows:

=IF(OR([Column1]>[Column2], [Column1]<[Column3]), "OK", "Not OK")

So try:

 =IF(OR([OH:Subsample ID]="ABC", ISBLANK([OH:Subsample ID])),"Audit")

The sample above came from this doc, which has other samples as well.

| improve this answer | |

You can use OR function to build such formula. Try using below formula:

=IF(OR([OH:Subsample ID]="ABC", ISBLANK([OH:Subsample ID])),"XYZ", "FalseValue")

In this formula I have combined IF and OR functions. For detailed syntax and examples check below references.


  1. OR function.
  2. IF function.
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.