urgent  - nested ifs
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: urgent - nested ifs

  1. #11
    New Member
    Join Date
    Apr 2013
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: urgent - nested ifs

    Quote Originally Posted by Joe4 View Post
    I was off a column in my grid, it is not A, B, C, but rather B, C, D. But I can now see what you are after.
    Since there are only two conditions that would return "Fail", let's check for those, and then have anything else return "Pass", i.e.
    Code:
    =IF(OR(AND(B1<>"",C1<>"",D1<>""),AND(B1<>"",D1<>"")),"Fail","Pass")

    Sorry i was missing last row of table:

    [cod]
    A Blank B Blank C Blank Result
    TRUE TRUE TRUE Pass
    TRUE TRUE FALSE Pass
    TRUE FALSE FALSE Pass
    TRUE FALSE TRUE Pass
    FALSE FALSE FALSE Fail
    FALSE FALSE TRUE Pass
    FALSE TRUE FALSE Fail
    FALSE TRUE TRUE Fail

  2. #12
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,427
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: urgent - nested ifs

    Then try this version:
    Code:
    =IF(B1="","Pass",IF(AND(B1<>"",C1<>"",D1=""),"Pass","Fail"))
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •