Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need a formula (Excel 2002)

    Cell A1 can be either a Y or N or Blank.
    Cell B1 can be either a Y or N or Blank..

    I need a formula for cell C1. If cell A1 has a Y and cell B1 has a Y - I want to automatically put a Y in cell C1 (using a formula).

    Thanks...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need a formula (Excel 2002)

    Try this:<pre>=IF(AND(A1="Y",B1="Y"),"Y","")</pre>

    or<pre>=IF(A1&B1="YY","Y","")</pre>

    I assumed that you wanted C1 to remain blank in all other cases.

Posting Permissions

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