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...
- For cells B23 to B40:
=IFERROR(IF(AND(C23="",H23=""),"",IF(AND(C23=H23, C23<>""), "T", IF(C23>H23, "W", "L"))), "")
This formula checks if both C23 and H23 are empty, and if so, it leaves the cell blank. If the scores are the same and not empty, it shows "T". Otherwise, it shows "W" or "L" based on the comparison.
- For cells C23 to C40:
To ensure that a score of 0 is treated as empty, you can use a custom number format. Select the range C23:C40, right-click, choose "Format Cells," and then go to the "Number" tab. Select "Custom" and enter the following format:
0;-0;;@