+ Reply to Thread
Results 1 to 6 of 6

IF AND Combined Formula with multiple Logical entries

  1. #1
    Registered User
    Join Date
    10-01-2019
    Location
    Bangkok Thailand
    MS-Off Ver
    2010
    Posts
    12

    IF AND Combined Formula with multiple Logical entries

    Hi All,

    I am trying to use an IF AND formula to return text based on Logical Values from 6 cells entered below.
    Is it possible to have this many logical values for this type of formula?

    If all the below cells are "True" should return "Achieve"
    If any one of the below cells are "False" should return "Fail"

    Below is the Syntax i'm trying to use....
    Appreciate your assistance

    =IF((AND(C5>=98,C7>=98,C6>=98,C8>=98,C9>=98,C10>=98,)),"Achieve","Fail")

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: IF AND Combined Formula with multiple Logical entries

    Try this
    =IF(AND(C5>=98,C6>=98,C7>=98,C8>=98,C9>=98,C10>=98),"Achieve","Fail")

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,176

    Re: IF AND Combined Formula with multiple Logical entries

    Or try:

    =IF(COUNTIF(C5:C10,">=98") = ROWS(C5:C10),"Achieve","Fail")

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: IF AND Combined Formula with multiple Logical entries

    Or
    =IF(MIN(C5:C10)<98,"Fail","Achieve")

  5. #5
    Registered User
    Join Date
    10-01-2019
    Location
    Bangkok Thailand
    MS-Off Ver
    2010
    Posts
    12

    Re: IF AND Combined Formula with multiple Logical entries

    Thank You, much appreciated

  6. #6
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: IF AND Combined Formula with multiple Logical entries

    You are welcome.

+ 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: 4
    Last Post: 08-07-2018, 08:30 AM
  2. [SOLVED] Logical formula in multiple criteria
    By amuljha in forum Excel General
    Replies: 6
    Last Post: 07-15-2017, 10:59 AM
  3. Multiple Logical Formula
    By amuljha in forum Excel General
    Replies: 5
    Last Post: 07-05-2017, 02:49 PM
  4. [SOLVED] Multiple entries combined in one cell
    By Barnapkin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2015, 12:47 AM
  5. Multiple outcomes from a logical formula
    By JoeHan in forum Excel General
    Replies: 6
    Last Post: 05-24-2012, 05:54 PM
  6. Logical formula for multiple input
    By sagulolo in forum Excel General
    Replies: 4
    Last Post: 03-07-2012, 06:57 PM
  7. Auto-Generating Entries based on combined Entries
    By Ice Burn in forum Excel General
    Replies: 3
    Last Post: 09-12-2011, 05:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1