SensualCarrots
New Member
- Joined
- Mar 21, 2015
- Messages
- 46
I am writing equations to check a cell for a range of values, which over time, will grow to be quite extensive. If the cell contains any of the specified values, then enter a particular value. I have the cell currently functioning like this:
=IF(OR(ISNUMBER(SEARCH("715",$G1)),ISNUMBER(SEARCH("717",$G1)),ISNUMBER(SEARCH("718",$G1)),ISNUMBER(SEARCH("94",$G1)))," -1"," ")
I would like to do something like this instead:
=IF(ISNUMBER(SEARCH(OR("715","717","718","94"),$G1))," -1"," ")
This would make things much easier in the future to add new values to my search. The formula does not give an error, but always returns a false value. Any thoughts? Thanks in advance!
=IF(OR(ISNUMBER(SEARCH("715",$G1)),ISNUMBER(SEARCH("717",$G1)),ISNUMBER(SEARCH("718",$G1)),ISNUMBER(SEARCH("94",$G1)))," -1"," ")
I would like to do something like this instead:
=IF(ISNUMBER(SEARCH(OR("715","717","718","94"),$G1))," -1"," ")
This would make things much easier in the future to add new values to my search. The formula does not give an error, but always returns a false value. Any thoughts? Thanks in advance!