Formula returns N/A even though condition is true

[Preacherman771]

Have an if statement returning N/A even though true. Cell EJ30 If(DD:30:EI30="32",0). When I check it's value it returns "True", but when I Ctr/Ret will receive "N/A". Even tried just hitting Ret, with same result. What am I doing wrong?

NFL Standing 2021.xlsx
	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK
30	CIN																																	#N/A	a
Calc_Playoff

Cell Formulas
Range	Formula
DC30	DC30	=AD30
DD30,DF30,DH30,DJ30,DL30,DN30,DP30,DR30,DT30,DV30,DX30,DZ30,EB30,ED30,EF30,EH30	DD30	=IF(OR(RIGHT($CY30)="x",RIGHT($CY30)="-",RIGHT($EG30)="x",RIGHT($EG30)="-",DD29="JAXx"),"", IF(DD29="JAX", (IF(AND(INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH($DC30,PlayRankDivAFC_Rnd1[Abr],0))=INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH(DD29,PlayRankDivAFC_Rnd1[Abr],0)), INDEX(TeamData[ConfDiv_Abr],MATCH($DC30,TeamData[Abr],0))=INDEX(TeamData[ConfDiv_Abr],MATCH(DD29,TeamData[Abr],0))), IFERROR(INDEX(SchedData[ResA],MATCH(1,($DC30=SchedData[Away])*(DD29=SchedData[Home]),0)),""),"")), IF(OR(RIGHT(DD29)="x",RIGHT(DD29)="-",$DC30=DD29),"", IF(AND(INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH($DC30,PlayRankDivAFC_Rnd1[Abr],0))=INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH(DD29,PlayRankDivAFC_Rnd1[Abr],0)), INDEX(TeamData[ConfDiv_Abr],MATCH($DC30,TeamData[Abr],0))=INDEX(TeamData[ConfDiv_Abr],MATCH(DD29,TeamData[Abr],0))), IFERROR(INDEX(SchedData[ResA],MATCH(1,($DC30=SchedData[Away])*(DD29=SchedData[Home]),0)),""),""))))
DE30,DG30,DI30,DK30,DM30,DO30,DQ30,DS30,DU30,DW30,DY30,EA30,EC30,EE30,EG30,EI30	DE30	=IF(OR(RIGHT($CY30)="x",RIGHT($CY30)="-",RIGHT($EG30)="x",RIGHT($EG30)="-",DD29="JAXx"),"", IF(DD29="JAX", (IF(AND(INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH($DC30,PlayRankDivAFC_Rnd1[Abr],0))=INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH(DD29,PlayRankDivAFC_Rnd1[Abr],0)), INDEX(TeamData[ConfDiv_Abr],MATCH($DC30,TeamData[Abr],0))=INDEX(TeamData[ConfDiv_Abr],MATCH(DD29,TeamData[Abr],0))), IFERROR(INDEX(SchedData[ResA],MATCH(1,($DC30=SchedData[Away])*(DD29=SchedData[Home]),0)),""),"")), IF(OR(RIGHT(DD29)="x",RIGHT(DD29)="-",$DC30=DD29),"", IF(AND(INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH($DC30,PlayRankDivAFC_Rnd1[Abr],0))=INDEX(PlayRankDivAFC_Rnd1[Gr],MATCH(DD29,PlayRankDivAFC_Rnd1[Abr],0)), INDEX(TeamData[ConfDiv_Abr],MATCH($DC30,TeamData[Abr],0))=INDEX(TeamData[ConfDiv_Abr],MATCH(DD29,TeamData[Abr],0))), IFERROR(INDEX(SchedData[ResH],MATCH(1,($DC30=SchedData[Home])*(DD29=SchedData[Away]),0)),""),""))))
EJ30	EJ30	=IF(OR(RIGHT(EK30)="x",RIGHT(EK30)="-"),"", IF(COUNTIF(DD30:EI30,"")=32,0, SUM(COUNTIF(DD30:EI30,"W")+(COUNTIF(DD30:EI30,"T")*0.5))/SUM(COUNTIF(DD30:EI30,"W")+COUNTIF(DD30:EI30,"L")+COUNTIF(DD30:EI30,"T"))))
EK30	EK30	=AC30

 

[Preacherman771]

While still editing the entire formulas, i.e., before hitting Ent, highlighted that portion which showed true. Only entered Ctr/Ent as an option to see if it made a difference. Always have simply hit Ent.

When checking the OR(RIGHT(. . . portion, showed false.

 

[Alex Blakenburg]

You don't have a circular error message in the bottom left corner of Excel do you ?

 

[Preacherman771]

Do not know how I missed it, but I do. It works fine. Even tested it by entering some W and/or L to see if it would do the correct SUM which it did. Thank you for your help.

 

[Alex Blakenburg]

You're welcome. Glad we could help.