Forum Discussion

sf49ers19238597

Iron Contributor

Nov 24, 2024

I have formulas that put things into cells

w l t in cells b23:b40 I need new formula b23 =IFERROR(IF(AND(C23="",H23=""),"",IF(C23=H23,"T",IF(C23>H23,"W","L"))),"") drop down to b40 It shows T. I don't want a T until the scores are the...

excel

Formulas and Functions

m_tarler

Bronze Contributor

Nov 27, 2024

The problem is probably in the formulas in C and H. They are probably returning " " (a space) instead of "" (no space). You could also update the formula to :

=IFERROR(IF(ISNUMBER(C23)*ISNUMBER(H23),IF(C23=H23,"T",IF(C23>H23,"W","L")),""),"")

this way it checks using ISNUMBER instead and if EITHER is not a number it will return ""