Results 1 to 2 of 2

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

This is a discussion on Please help. If A, B, and C, then... within the Excel Questions forums, part of the Question Forums category; Please tell me if Excel can evaluate three cells, then input a value in a fourth cell based on a ...

  1. Jul 10th, 2010, 09:16 PM #1
    tvc15
    tvc15 is offline
    New Member
    Join Date
    Jan 2009
    Posts
    15

    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.
    Reply With Quote Reply With Quote
  2. Jul 10th, 2010, 09:18 PM #2
    Special-K99
    Special-K99 is offline
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    2,500

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

    =IF(OR(A1="",B1="",C1=""),"Does not apply","Does apply")
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


DMCA.com