[code]=IF(ISERROR(SEARCH("pool",LOWER(A2),1)),IF(ISERROR(SEARCH("pool",LOWER(B2),1)),IF(ISERROR(SEARCH("pool",LOWER(C2),1)),FALSE,TRUE),TRUE),TRUE)[/code]
The problem was that if the string wasn't in the text it would return an error. Any other examples of excel being a bitch?
Why is this in the programming forum?
I guess because it's 'scripting'.
okay what
This isn't PHP at all, YOU LIED TO ME.
Sorry, you need to Log In to post a reply to this thread.
