Excel Formula
Budget: $10 – $30 AUD
I want someone to give me a formula in excel.
If a cell has certain numbers in it then it would say Yes if not then blank
I can get it to work on 1 number but not multiple
=IF(ISNUMBER(SEARCH("18",A2)),"Yes","No")
If a cell has certain numbers in it then it would say Yes if not then blank
I can get it to work on 1 number but not multiple
=IF(ISNUMBER(SEARCH("18",A2)),"Yes","No")