Using If Function but ignoring if cells are blank

[geparden8450143]

I am trying to use the formula below:

=IF(Q26>R26,"W",IF(Q26=R26,"D",IF(R26>Q26,"L",FALSE)))

However, I want the formula to be ignored if the cells referred to are blank e.g. if Q26=R26 but both are blank, I don't want the result to be "D"

Any help or suggestions greatly appreciated.

 

[godsaaint]

try:

=IF(AND(Q26="",R26=""),"",IF(Q26>R26,"W",IF(Q26=R26,"D",IF(R26>Q26,"L",FALSE))))

 

[Tetra201]

Is this what you need?

=IF((Q26="")*(R26=""),"",IF(Q26 > R26,"W",IF(Q26 < R26,"L","D")))<r26,"l","d")))< html=""></r26,"l","d")))<>

 

[geparden8450143]

try:

=IF(AND(Q26="",R26=""),"",IF(Q26>R26,"W",IF(Q26=R26,"D",IF(R26>Q26,"L",FALSE))))

Thanks for responding.

Tried this but it still gives the result "D" even when both Q26 & R26 are blank/empty cells?

Michael

 

[geparden8450143]

Is this what you need?

=IF((Q26="")*(R26=""),"",IF(Q26 > R26,"W",IF(Q26 < R26,"L","D")))<r26,"l","d")))< html=""></r26,"l","d")))<>

Thanks for responding.

Tried this but it still gives the result "D" even when both Q26 & R26 are blank/empty cells?

Michael

 

[Tetra201]

... Tried this but it still gives the result "D" even when both Q26 & R26 are blank/empty cells...

This means they are not really blank/empty.

Try =CODE(Q26) and =CODE(R26) on your "blank/empty" cells. What do you get?

 

[geparden8450143]

This means they are not really blank/empty.

Try =CODE(Q26) and =CODE(R26) on your "blank/empty" cells. What do you get?

Hi again,

Q26 & R26 each have an INDEX & MATCH formula in. The INDEX MATCH formula refer to two other cells which are empty. So if those two other cells each have e.g. "3" in, I want to display "D" because they are the same BUT if those two other cells are both BLANK I don't want "D" to be displayed, I want nothing to be displayed. Don't know if this explanation makes sense but thanks again for helping.

Michael