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 same.
C23:C40
I want score be empty see 0. if put 0 -0 than put T
Thanks You
8 Replies
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 ""
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
I need new formula for b23:b40
Bro why need new formula? Your query is quite lacking, we didn't know what's in your mind or what you're working in to, provide more information on what you want to do on the new formula, it seems the provided answer was working.
- 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;;@
