IFS

[gtd526]

Hello,
Regarding AA25.
IF Z25 and Z26 are 0, then ""

thank you

NBA.xlsm
	Z	AA
21	4
22	6	SAC
23	5	Tie
24	5
25	0	Tie
26	0
27	0	Tie
28	0
Favs

Cell Formulas
Range	Formula
Z21,Z27,Z25,Z23	Z21	=COUNTIF(N21,">"&N22)+COUNTIF(O21,">"&O22)+COUNTIF(P21,">"&P22)+COUNTIF(Q21,">"&Q22)+COUNTIF(R21,">"&R22)+COUNTIF(S21,">"&S22)+COUNTIF(T21,">"&T22)+COUNTIF(U21,">"&U22)+COUNTIF(V21,"<"&V22)+COUNTIF(W21,">"&W22)
AA21,AA27,AA23	AA21	=IFERROR(IF(Z21>Z22,A21,IF(Z21=Z22,"Tie","")),"")
Z22,Z28,Z26,Z24	Z22	=COUNTIF(N22,">"&N21)+COUNTIF(O22,">"&O21)+COUNTIF(P22,">"&P21)+COUNTIF(Q22,">"&Q21)+COUNTIF(R22,">"&R21)+COUNTIF(S22,">"&S21)+COUNTIF(T22,">"&T21)+COUNTIF(U22,">"&U21)+COUNTIF(V22,"<"&V21)+COUNTIF(W22,">"&W21)
AA22,AA28,AA26,AA24	AA22	=IFERROR(IF(Z22>Z21,A22,""),"")
AA25	AA25	=IFS(Z25>Z26,A25,Z25=Z26,"Tie",Z25=0,"")

 

[Fluff]

How about

=IFS(Z25>Z26,A25,AND(Z25=0,Z26=0),"",Z25=Z26,"Tie")

but what should happen if Z26>Z25?

 

[gtd526]

How about

=IFS(Z25>Z26,A25,AND(Z25=0,Z26=0),"",Z25=Z26,"Tie")

but what should happen if Z26>Z25?

I had 2 different formulas for AA21 & AA22 (in pairs). So with your formula, I've combined the 2.
IFS($Z25>$Z26,$A25,$Z25<$Z26,"",AND($Z25=0,$Z26=0),"",$Z25=$Z26,"Tie")
thank you

Here is the outcome:

NBA.xlsm
	Z	AA
4	Pick	Teams
5	1
6	9	LAC
7	7	BRK
8	3
9	7	ORL
10	3
11	9	SAN
12	1
13	3
14	7	CLE
15	8	MIL
16	2
17	1
18	9	IND
19	2
20	7	CHI
21	4
22	6	SAC
23	5	Tie
24	5	Tie
25	0
26	0
27	0
28	0
29	0
30	0
Favs

Cell Formulas
Range	Formula
Z5,Z29,Z27,Z25,Z23,Z21,Z19,Z17,Z15,Z13,Z11,Z9,Z7	Z5	=COUNTIF(N5,">"&N6)+COUNTIF(O5,">"&O6)+COUNTIF(P5,">"&P6)+COUNTIF(Q5,">"&Q6)+COUNTIF(R5,">"&R6)+COUNTIF(S5,">"&S6)+COUNTIF(T5,">"&T6)+COUNTIF(U5,">"&U6)+COUNTIF(V5,"<"&V6)+COUNTIF(W5,">"&W6)
AA5,AA29,AA27,AA25,AA23,AA21,AA19,AA17,AA15,AA13,AA11,AA9,AA7	AA5	=IFS($Z5>$Z6,$A5,$Z5<$Z6,"",AND($Z5=0,$Z6=0),"",$Z5=$Z6,"Tie")
Z6,Z30,Z28,Z26,Z24,Z22,Z20,Z18,Z16,Z14,Z12,Z10,Z8	Z6	=COUNTIF(N6,">"&N5)+COUNTIF(O6,">"&O5)+COUNTIF(P6,">"&P5)+COUNTIF(Q6,">"&Q5)+COUNTIF(R6,">"&R5)+COUNTIF(S6,">"&S5)+COUNTIF(T6,">"&T5)+COUNTIF(U6,">"&U5)+COUNTIF(V6,"<"&V5)+COUNTIF(W6,">"&W5)
AA6,AA30,AA28,AA26,AA24,AA22,AA20,AA18,AA16,AA14,AA12,AA10,AA8	AA6	=IFS($Z6>$Z5,$A6,$Z6<$Z5,"",AND($Z6=0,$Z5=0),"",$Z6=$Z5,"Tie")

 

[Fluff]

In that case you can combine them like

=IFS(Z25>Z26,A25,OR(Z25<Z26,AND(Z25=0,Z26=0)),"",Z25=Z26,"Tie")

 

[gtd526]

In that case you can combine them like

=IFS(Z25>Z26,A25,OR(Z25<Z26,AND(Z25=0,Z26=0)),"",Z25=Z26,"Tie")

I combined them for:
IFS($Z5>$Z6,$A5,$Z5<$Z6,"",AND($Z5=0,$Z6=0),"",$Z5=$Z6,"Tie")

I noticed you used OR, but they seem to do the same?? as I've tested both of them. Is there any difference?

 

[Fluff]

Is there any difference?

Not really, just another way of doing it as both criteria return ""

 

[gtd526]

Not really, just another way of doing it as both criteria return ""

No problem. I'll use your OR, rather be safe, than sorry.

Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.