0

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")
1
  • Do you want the exact match of "ABC" or the field value contains substring "ABC" inside it's value? Sep 14, 2019 at 4:31

2 Answers 2

0

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.

0

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.

Reference:

  1. OR function.
  2. IF function.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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