Results 1 to 7 of 7

Thread: if with 2 condition

  1. #1
    Board Regular
    Join Date
    Mar 2011
    Location
    Saudi Arabia
    Posts
    199
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default if with 2 condition

    I have many account numbers in column A but if account 501000 & 511000 comes then text required in Cell B1 is "Good" else blank.

    I only know formula as follows, how to add 511000 also in the formula ?

    =If($A$1:$A$1000="501000","Good","")

  2. #2
    Board Regular
    Join Date
    May 2019
    Posts
    180
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: if with 2 condition

    =If(or(A1 ="501000",A1= "511000","Good",""))
    Paste into row 1 and drag it down

    Please note if 501000 are formatted as numbers then you should set them like this A1 = 501000 without the quotations, the formula with "501000" or "511000" will only work if they are text formatted
    Last edited by Twollaston; Jun 9th, 2019 at 02:11 AM.

  3. #3
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,122
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: if with 2 condition

    Hi,

    Formula suggested in Post # 2 has a misplaced bracket, should be:

    =IF(OR(A1="501000",A1="511000"),"Good","")

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,508
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: if with 2 condition

    You can also use this way:



    =IF(OR(A1={"501000","511000"}),"Good","")
    Regards Dante Amor

  5. #5
    Board Regular
    Join Date
    Mar 2011
    Location
    Saudi Arabia
    Posts
    199
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: if with 2 condition

    Thanks all

  6. #6
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,122
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: if with 2 condition

    You're welcome.

  7. #7
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,508
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: if with 2 condition

    Quote Originally Posted by Salamullah View Post
    Thanks all
    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

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
  •