Results 1 to 19 of 19

Turn cell a5 to TRUE if cells b5,c5,d5 equal yes

Threaded View

  1. 01-18-2016, 04:56 PM #19
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,693

    Re: Turn cell a5 to TRUE if cells b5,c5,d5 equal yes 

    =IF(COUNTIF(D9:D14;"no")>0;"Fail";IF(COUNTIF(D9:D14;"-")>0;"-";"Pass"))
    How about this formula?
    Attached Files Attached Files
    Last edited by popipipo; 01-18-2016 at 05:21 PM. Reason: attachment
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
« 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. Accumulate time when true and when false turn it to zero.
    By pedrohern in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2015, 05:02 AM
  2. Accumulate time when true and when false turn it to cero.
    By pedrohern in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2015, 12:36 PM
  3. macro to open userform1 turn optionbox1 to true and click commandbutton1
    By Jenkins27 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2015, 09:20 PM
  4. Conditional formatting if two value equal true
    By grantsmith in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2013, 07:05 AM
  5. Check if two cells are equal and copy,paste cell if true
    By solomeros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2011, 01:22 AM
  6. Toggle Button set to true if cell is equal to text
    By ravergirl7216 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2010, 02:03 PM
  7. True, False and equal
    By scousepete79 in forum Excel General
    Replies: 3
    Last Post: 08-26-2007, 04:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1