Please help. If A, B, and C, then...

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Please help. If A, B, and C, then...

  1. #1
    New Member
    Join Date
    Jan 2009
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Please help. If A, B, and C, then...

     
    Please tell me if Excel can evaluate three cells, then input a value in a fourth cell based on a condition.

    For example, if cell A1, or Cell B1, or Cell C1 is blank, then code "Does not apply" in cell D1.

    I have over 2000 rows to inspect, and if there is a formula, it will be a great time saver.

    Thank you in advance.

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    6,497
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Please help. If A, B, and C, then...

      
    =IF(OR(A1="",B1="",C1=""),"Does not apply","Does apply")

User Tag List

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
  •  

 

 
DMCA.com