Forum Discussion
Solved
Using formula to display a message if a certain number is shown in a column
Hello,
I am trying to get Excel to look at the column I have highlighted for some certain numbers, and if those numbers are in that column I want to display a message. I tried using some different IF formulas but was not having any luck. Does anyone here have any ideas?
Thank you!
Maybe like this.
=IF(OR(ISNUMBER(SEARCH(3,D3)),ISNUMBER(SEARCH(9,D3))),"output message","")This is the formula in cell F3 in the example.
=IF(OR(D3=4108177,D3=4248742),"certain message","")This is the formula in cell E3 in the example.
Maybe like this.
=IF(OR(ISNUMBER(SEARCH(3,D3)),ISNUMBER(SEARCH(9,D3))),"output message","")This is the formula in cell F3 in the example.
=IF(OR(D3=4108177,D3=4248742),"certain message","")This is the formula in cell E3 in the example.
- Thank you, I just had to tweak it a little bit but this solved my problems!
