Hi,
Source: Excel if cell contains partial text - Excel
I've successfully added this function to my spreadsheet: =IF(COUNTIF(A2,"*PartialText*"),"Yes","No")
I'm wondering how do you add multiple countif(s) in the same formula ? For example, if a cell contains some text, then display this…but if it contains another text, then display something else, and so on ?
thanks
Christian
Source: Excel if cell contains partial text - Excel
I've successfully added this function to my spreadsheet: =IF(COUNTIF(A2,"*PartialText*"),"Yes","No")
I'm wondering how do you add multiple countif(s) in the same formula ? For example, if a cell contains some text, then display this…but if it contains another text, then display something else, and so on ?
thanks
Christian