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