Use of Combined IF and AND statements

  • Thread starter Thread starter ConfusedNHouston
  • Start date Start date
C

ConfusedNHouston

I have a situation where I want to apply the following argument

If A1 isn't blank and if A1 equals A2, put the value from C1 in D1.

If blank, enter ""

How do i combine or 'nest' the IF and the AND statements? Just for future
reference can I have several "AND's" in a row?

Thanks. I know this is "kindergarten" stuff but I can't find it in the
Excel help file and I need to set this up.
 
This may work for you. Put this in D1:

=IF(AND(A1<>"",A1=A2),C1,"")

Tyro
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with if statement 1
Nested IF Help 3
repeat calculation for different combination of input? 11
Combining 2 IF statements 3
Basic IF/AND and Nested IF/AND Statements? 2
If statement for a range of cells 3
IF statements - 26 combinations 21
Nested IF statement 3

Back
Top