+ Reply to Thread
Results 1 to 3 of 3

Formula to check if certain cells holds data and report True/False accordingly

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Question Formula to check if certain cells holds data and report True/False accordingly

    Hi,

    Can anyone please advise me of the formula required I need to insert in cell ‘J2’ that will check to see if there is data in cell ‘A2’ and cells ‘D2’ ‘E2’, ‘F2’, ‘G2’, ‘H2, and ‘I2’.

    If there is data in every cell ‘J2’ should say ‘True’ otherwise if any of the cells does not hold data, then ‘J2’ should say ‘False’.

    Any assistance received would be greatly appreciated

    Many thanks in advance

    Regards

    Rob
    Rob

  2. #2
    Valued Forum Contributor Hydraulics's Avatar
    Join Date
    07-15-2018
    Location
    Udine - Italy
    MS-Off Ver
    Office 365
    Posts
    373

    Re: Formula to check if certain cells holds data and report True/False accordingly

    Try with

    =AND(A2<>"",D2<>"",E2<>"",F2<>"",G2<>"",H2<>"",I2<>"")
    Aim high or don't even try.
    ---------------------------------
    If your question has been answered, don't forget to mark the thread as SOLVED.
    If you find an answer helpful, click on the star icon at the bottom of the post.

  3. #3
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Formula to check if certain cells holds data and report True/False accordingly

    Hi,

    Another way:

    =AND(A2<>"",COUNTA(D2:I2)=6)

+ 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. Automatically Mark a check box using True/False imported data from worksheet
    By Mark Dynes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2017, 10:54 AM
  2. [SOLVED] Check if cells An and Bn have specific content and show true/false in Cn
    By iyoossaev in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-02-2015, 06:36 AM
  3. Replies: 3
    Last Post: 09-28-2014, 08:14 PM
  4. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  5. [SOLVED] A check for comparing two pieces of data, true/false
    By MushroomFace in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 08:28 PM
  6. If formula with true/false check box options
    By jamierat in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-21-2011, 08:48 PM
  7. Vlookup to report True or false
    By Dendrinos2 in forum Excel General
    Replies: 1
    Last Post: 11-30-2011, 12:04 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