Forum Discussion

rhiheu's avatar
rhiheu
Copper Contributor
Jun 16, 2020
Solved

Multiple FIND functions

Hi, I would like to expand on https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?ui=en-us&rs=en-us&ad=us formula in my Sh...
Lists
SharePoint Online
  • Vikram_Samal's avatar
    Vikram_Samal
    Jun 16, 2020

    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.

Vikram_Samal's avatar
Vikram_Samal
MCT
Jun 16, 2020

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.

rhiheu's avatar
rhiheu
Copper Contributor
Jun 17, 2020

That works perfectly, thanks Vikram_Samal!

Resources