+ Reply to Thread
Results 1 to 2 of 2

Formula that need to display yes or no based on a full row of yes / no questions

  1. 08-31-2021, 05:53 AM #1
    davo3286
    davo3286 is offline
    Forum Contributor
    Join Date
    06-07-2018
    Location
    Newcastle Upon Tyne, England
    MS-Off Ver
    365
    Posts
    143

    Formula that need to display yes or no based on a full row of yes / no questions

    Return "Yes" or "No" depending on answers across each row.

    Example with explanation attached.

    Thanks as always!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-31-2021, 06:08 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Formula that need to display yes or no based on a full row of yes / no questions

    You can use this formula in F2:

    =IF(COUNTIF(Table1[@[Q1]:[Q5]],"Yes"),"Yes","No")

    It should copy down automatically.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula showing decision based on Several questions
    By iamblaine in forum Excel General
    Replies: 1
    Last Post: 01-28-2020, 11:25 AM
  2. [SOLVED] Amend formula to display full month name as part of file name format
    By robertguy in forum Excel General
    Replies: 4
    Last Post: 04-19-2018, 10:59 AM
  3. [SOLVED] More data identification formula questions - Compare, Validate and Display
    By Doofus1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-14-2018, 02:48 PM
  4. Display Full Screen
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2014, 04:35 PM
  5. [SOLVED] Display Full Screen
    By Tony Hadj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 04:44 AM
  6. code to display next page of multipage form based on answer to questions on existing page
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2014, 02:23 AM
  7. Display abbreviation from full name
    By snoopy1461 in forum Excel General
    Replies: 2
    Last Post: 05-26-2011, 06:21 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1