Multiple FIND functions

[rhiheu]

Hi,

I would like to expand on this formula in my SharePoint Online list calculated column:

=IF(ISNUMBER(FIND("v",[Column1])), "OK", "Not OK")

I would like to find multiple different separate sections of text, e.g. when 'v' or 'ab' or 'de' is present, to return 'OK'.

Is that possible?

Thanks.

[#2 · Accepted solution]

@rhiheuYes it is possible, please find the test replication:

The formula will look something like this:

=IF(OR(ISNUMBER(FIND("v",Value)), ISNUMBER(FIND("ab",Value)),ISNUMBER(FIND("de",Value))), "OK", "Not OK")

Thanks,
Vik
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[#3]

That works perfectly, thanks @Vikram_Samal!