Hi, I've read the excellent post on nested IF AND syntax, but I have one thing I can't solve. Scenario: If cell A1 contains either "Value1" or "Value2" and cell C1 is empty, then value of cell D1 = "1". Thus:

=IF(AND(A1= "Value1",C1=""),1, (IF(AND(A1= "Value2",C1=""),1))). This in itself works fine, but, what I want is for cell D1 to be blank if a value is put in cell C1. It currently puts "FALSE" in cell D1. Any help much appreciated.

I think I've sorted this. I added empty speech marks after the last result: 1,"")). That produces a blank D1 cell.

Just in case you aren't aware of why the double quotes fixed the problem, here's why: If you don't supply a

value_if_falseargument for a IF function, Excel will automatically return FALSE when thelogical_testis not TRUE.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thanks DerbyDad03, much appreciated!

Ask Your Question

Weekly Poll