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",)
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",)
Maybe:
Formula:Please Login or Register to view this content.
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
If someone has helped you then please add to their Reputation
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?
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
=IF(AND(ISNUMBER(SEARCH("SBHS",B3)),B3<>"Bye",C3=""),"I",IF(AND(E3="",F3=""),"I","O"))
Try this.
=if(and(isnumber(search("sbhs",b3)),$c3="",or($e3="",$f3="")),"i","")
Thanks guys...it works only of cell B3 contains "SBHS" only. not if it contains"SBHS 77"
Sorry guys...my fault its all good. Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks