+ Reply to Thread
Results 1 to 9 of 9

If more than one cell contains certain information

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    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. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: If more than one cell contains certain information

    Maybe:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    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
    If someone has helped you then please add to their Reputation

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    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. #5
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    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. #6
    Registered User
    Join Date
    08-22-2015
    Location
    Dhaka
    MS-Off Ver
    office 8
    Posts
    33

    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. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: If more than one cell contains certain information

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

  8. #8
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    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. #9
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Re: If more than one cell contains certain information

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-12-2015, 06:14 PM
  2. Replies: 4
    Last Post: 02-28-2014, 02:56 PM
  3. Transfer cell information into a new free cell and clean after pressing enter
    By juliangun4ev in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2013, 03:57 AM
  4. Replies: 2
    Last Post: 06-08-2011, 02:36 PM
  5. Replies: 2
    Last Post: 12-24-2009, 02:58 PM
  6. Transfer single cell information to specific cell based on user criteria
    By RoVo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2006, 11:30 AM
  7. Auto-fill cell based on adjacent cell information..
    By sans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2005, 07:05 PM

Bookmarks

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