My question is can you do an IF technically I think it would be a nested if when all the criteria is in the same cell? The attachment only shows 2 items but cell A2 could have as many as 5 items. I have an if and in cell F2, but I need to get this part worked out. Where I want to be is a sum enclosing the if statement to sum the missed items.
Well. Not pretty, but the formula works.
=IF(OR(NOT(ISERROR(SEARCH("demoS",A2))),NOT(ISERROR(SEARCH("at&t services",A2))),NOT(ISERROR(SEARCH("sims",A2)))),1,0)
JieJenn,
While it does return a value, it is only returning 1, when there are two conditions listed. Shouldn't it return both. I apologize, I'm still learning if statements.
Maybe the site will gives a clear explanation on IF statement
http://www.techonthenet.com/excel/formulas/if.php
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks