|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.