Forum Discussion

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

Multiple FIND functions

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.

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
    Steel Contributor
    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.

Resources