#REF! Error Resolve?
 

The formula below will produce the #REF! Error in cell L4 until data is input
in cells A4 and B4. Once data is input, the #REF! error will go away, and be
replaced with a numerical outcome of 0 or 1.

Is there an addition to the formula below which I can use to just leave the
cell "blank" until the data is input in A4 and B4. I just hate seeing that
#REF! Error!

=IF(AND(SUMPRODUCT(--(rnga<""),--(rngb<""),--(rnga=$A4),--(rngb=$B4))1,C4<"x"),1,0)

Thanks,

Dan

#REF! Error Resolve?
 

If you use another clause in your IF statement that precedes what you have,
it should work like you're expecting. Try inserting:

=IF(COUNTA(A4:B4)<2,"",YOUR_STATEMENT)

YOUR_STATEMENT is what you already have.

HTH

"Dan the Man" wrote:

The formula below will produce the #REF! Error in cell L4 until data is input
in cells A4 and B4. Once data is input, the #REF! error will go away, and be
replaced with a numerical outcome of 0 or 1.

Is there an addition to the formula below which I can use to just leave the
cell "blank" until the data is input in A4 and B4. I just hate seeing that
#REF! Error!

=IF(AND(SUMPRODUCT(--(rnga<""),--(rngb<""),--(rnga=$A4),--(rngb=$B4))1,C4<"x"),1,0)

Thanks,

Dan

#REF! Error Resolve?
 

Thanks much! That did it!

"Dan the Man" wrote:

The formula below will produce the #REF! Error in cell L4 until data is input
in cells A4 and B4. Once data is input, the #REF! error will go away, and be
replaced with a numerical outcome of 0 or 1.

Is there an addition to the formula below which I can use to just leave the
cell "blank" until the data is input in A4 and B4. I just hate seeing that
#REF! Error!

=IF(AND(SUMPRODUCT(--(rnga<""),--(rngb<""),--(rnga=$A4),--(rngb=$B4))1,C4<"x"),1,0)

Thanks,

Dan