Forum Discussion
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 calculated, otherwise something else.
3 Replies
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=IF(LEN(A9&A12&A16&A19)-LEN(SUBSTITUTE(A9&A12&A16&A19,"x",""))>0,"x","")You can try this formula.
