View Poll Results: IF AND OR Statement, not working need help

Voters
0. This poll is closed
  • IF AND or OR function is not giving correct result, need help

    0 0%
  • IF Logical function

    0 0%
Multiple Choice Poll.
Page 1 of 4 1 2 3 ... LastLast
Results 1 to 10 of 34

Thread: IF AND OR excel statement

  1. #1

    IF AND OR excel statement



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Experts,

    I am hoping to get help from this forum, see below my comment and the work book attached.
    If D5, E5, F5, G5, H5... = C,Z,"" give "Comp"
    if there is any other values other than or along with C,Z,"" in cell D5, E5, F5, G5, H5... then give "No". for example if any the cells contains O,I,C,Z,"" then give "No"

    here is my formula working which is not working. Please see formulas Col. P Q R in sheet 1
    IF(OR(D5="C",E5="C",F5="C",G5="C",H5="C",I5="C",J5="C",K5="C"),IF(OR(D5="",E5="",F5="",G5="",H5="",I5="",J5="",K5=""),IF(OR(D5="z",E5="Z",F5="Z",G5="Z",H5="Z",I5="Z",J5="Z",K5="Z"),"Complete","No")))

    Thank you folks.IF OR AND Formula fix.xlsx

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    901
    Articles
    0
    Excel Version
    Office 365 Subscription
    You are using the OR function so this is conradictory:

    If D5, E5, F5, G5, H5... = C,Z,"" give "Comp"
    if there is any other values other than or along with C,Z,"" in cell D5, E5, F5, G5, H5... then give "No". for example if any the cells contains O,I,C,Z,"" then give "No"
    Please attach the workbook again, but this time fill column P manually with the results you want.

    You are using the OR
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,357
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Why did you create a poll?
    Thank you Ken for this secure forum.

  4. #4
    ALiGW, Thank you for your prompt reply.
    Column P is manually filled.

    Thank you for help
    Attached Files Attached Files
    Last edited by NK123; 2018-04-08 at 05:02 PM.

  5. #5
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,357
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please answer my question
    Thank you Ken for this secure forum.

  6. #6
    Quote Originally Posted by Pecoflyer View Post
    Please answer my question
    Pecoflyer, AliGW asked me to.

    Thank you.

  7. #7
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    901
    Articles
    0
    Excel Version
    Office 365 Subscription
    No, I did not ask you to start a poll!

    I asked you to add manually entered expected results to your workbook and then attach it again here.

    I have closed the poll.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    I not understanding about the poll, what is this. Is it different to thread I have created?
    Last edited by NK123; 2018-04-08 at 10:32 PM.

  9. #9
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    901
    Articles
    0
    Excel Version
    Office 365 Subscription
    Look at the top of the thread - you must have added it when you started the thread.

    No matter - just forget it now. I will look at your attachment tomorrow.
    Ali
    Enthusiastic self-taught user of MS Excel!

  10. #10
    Quote Originally Posted by AliGW View Post
    Look at the top of the thread - you must have added it when you started the thread.

    No matter - just forget it now. I will look at your attachment tomorrow.
    Thank you AliGW.

Page 1 of 4 1 2 3 ... LastLast

Tags for this Thread

Posting Permissions

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