Forum Discussion
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...
Thanks You
Try this formula: =IFERROR(IF(AND(C23<=0,H23<=0),"",IF(C23=H23,"T",IF(C23>H23,"W","L"))),"")
it working.
but I saw problem it have one T when you see bye should be empty cell. I hightlight. bottom picture I want.
Thanks You
Mine's working well whether it's empty or with 0s', Is there a formula on column C and H? are they really totally empty/blank? Or have you integrated the formula with another one that referencing on column D?