Forum Discussion

Copper Contributor

Jun 23, 2022

examining the contents of multiple cells in Excel

Can the IF function (or something else) be used to examine the contents of multiple cells so that if a particular character/number is found at least in one of those cells, something specific is calc...

excel

Formulas and Functions

OliverScheurich

Gold Contributor

Jun 23, 2022

Jukka705

=IF(ISNUMBER(MATCH("*"&E4&"*",C4:C8,0)),F6*0.9,F6)

Is this similar to what you want to do?

Jukka705
Copper Contributor
Jun 23, 2022
Not quite, but almost.
If I describe in more detail:

I want to check if any of the cells A9, A12, A16, A19 have a character "x".
And if at least one is found, want to write "x" in cell A21 as well.
Otherwise, leave the cell A21 empty
- OliverScheurich
  Gold Contributor
  Jun 23, 2022
  Jukka705
  =IF(LEN(A9&A12&A16&A19)-LEN(SUBSTITUTE(A9&A12&A16&A19,"x",""))>0,"x","")
  You can try this formula.