# If more than one cell contains certain information

1. ## If more than one cell contains certain information

Hi,

I am trying to make a cell display "I" when more than one cell contains certain information. The formula is below. I hope this makes sense.

Thanks,

=IF(ISNUMBER(SEARCH("SBHS",B3),AND(\$B3<>"Bye",\$C3="",OR(\$E3="",\$F3="")),"I",)

2. ## Re: If more than one cell contains certain information

Maybe:

Formula:
`Please Login or Register  to view this content.`

3. ## Re: If more than one cell contains certain information

Can you write what you're looking to do in plain English rather than formula?

eg IF White = Black AND IF Either Yellow doesnt = Sausages OR 5 is greater than 4

It'll make it easier to come up with the answer as Im not sure whether you're looking to do the OR as part of the AND or not

4. ## Re: If more than one cell contains certain information

You appear to have conflicting tests in B3 re "SBHS" and "Bye" and the cell references are conflicting B3 vs \$B3.

Can you state your tests in a non-formula way?

5. ## Re: If more than one cell contains certain information

Ok sorry. Will try and explain further:

The formula will be placed in D3, Therefore if cell B3 contains the text "SBHS" (keep in mind the cell may contain "SBHS 77" or "SBHS 65") and at the same time C3="",OR(\$E3="",\$F3="")) then I want cell D3 to display "I"

Again I hope this helps. If not please let me know.

I tried the above formula from zbor but it says I entered too many arguments

6. ## Re: If more than one cell contains certain information

=IF(AND(ISNUMBER(SEARCH("SBHS",B3)),B3<>"Bye",C3=""),"I",IF(AND(E3="",F3=""),"I","O"))

Try this.

7. ## Re: If more than one cell contains certain information

=if(and(isnumber(search("sbhs",b3)),\$c3="",or(\$e3="",\$f3="")),"i","")

8. ## Re: If more than one cell contains certain information

Thanks guys...it works only of cell B3 contains "SBHS" only. not if it contains"SBHS 77"

9. ## Re: If more than one cell contains certain information

Sorry guys...my fault its all good. Thank you very much

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1