Ignore cell IF error

[gtd526]

Hello,
I have a nested IF formula, if a cell contains an error, how can I ignore only that cell (and continue calculating the remaining cells)?
Column H:H contains the nestedIF statement. The error is AJ.
Thank you.

NBA.xlsm
	A	B	C				G	H	I																					AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM
2	5/3/21						ME																								ALL W%	Bet W%		Avg	Ind %	ATS	vs All	Away vs
3	Teams	ATS	'W-L				Indicator	Pick	ATS																					Favs			Inj's	Pts	G:G	Range	ATS	Home	Strk
4	ORL	2																													39%		8	358		25%	39.0%	50.0%	W1
5	DET	-2					R:T-M																							DET	52%	100%	7	558	72.2%	100%	52.0%	57.0%	L2
6	IND	4					U:V-Y																								47%	100%	6	583	49.8%	0%	47.0%	55.0%	W1
7	WAS	-4					R:T-M	#####	######																					WAS	65%	100%	2	243	72.2%	#VALUE!	65.0%	52.0%	L1
8	GS	2																												GS	53%	40%	5	397		75%	53.0%	38.0%	W1
9	NO	-2																													55%	33%	4	430		17%	55.0%	46.0%	W2
Favs

Cell Formulas
Range	Formula
A2	A2	=TODAY()
G4,G8,G6	G4	=IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$W4>$W5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$M4>$M5),"R:Z-M",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$W4>$W5,$X4>$X5,$Y4>$Y5,$Z4>$Z5),"R:Z",IF(AND($M4>$M5,$Q4>$Q5,$R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-Q-R:V-X:Z-W",IF(AND($M4>$M5,$Q4>$Q5,$R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-Q-R:V-Y:Z-W",IF(AND($M4>$M5,$R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-R:V-X:Z-W",IF(AND($M4>$M5,$R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-R:V-Y:Z-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"R:V-X:Z-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"R:V-Y:Z-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$X4>$X5,$Y4>$Y5,$Z4>$Z5),"R:V-X:Z",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Y4>$Y5,$Z4>$Z5),"R:V-Y:Z",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$M4>$M5,$Q4>$Q5,$W4>$W5),"R:V-M-Q-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$M4>$M5,$W4>$W5,$Y4>$Y5),"R:V-M-W-Y",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Q4>$Q5,$W4>$W5),"R:V-Q-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$W4>$W5,$Y4>$Y5),"R:V-W-Y",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Q4>$Q5),"R:V-Q",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$W4>$W5),"R:V-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$Y4>$Y5),"R:V-Y",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5,$M4>$M5),"R:V-M",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$U4>$U5,$V4>$V5),"R:V",IF(AND($M4>$M5,$Q4>$Q5,$R4>$R5,$S4>$S5,$T4>$T5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-Q-R:T-X:Z-W",IF(AND($M4>$M5,$Q4>$Q5,$R4>$R5,$S4>$S5,$T4>$T5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-Q-R:T-Y:Z-W",IF(AND($M4>$M5,$R4>$R5,$S4>$S5,$T4>$T5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-R:T-X:Z-W",IF(AND($M4>$M5,$R4>$R5,$S4>$S5,$T4>$T5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"M-R:T-Y:Z-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$X4>$X5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"R:T-X:Z-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$Y4>$Y5,$Z4>$Z5,$W4>$W5),"R:T-Y:Z-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$X4>$X5,$Y4>$Y5,$Z4>$Z5),"R:T-X:Z",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$Y4>$Y5,$Z4>$Z5),"R:T-Y:Z",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$M4>$M5,$Q4>$Q5,$W4>$W5),"R:T-M-Q-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$M4>$M5,$W4>$W5,$Y4>$Y5),"R:T-M-W-Y",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$Q4>$Q5,$W4>$W5),"R:T-Q-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$J4>$J5,$Y4>$Y5),"R:T-J-Y",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$J4>$J5),"R:T-J",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$M4>$M5),"R:T-M",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$W4>$W5),"R:T-W",IF(AND($R4>$R5,$S4>$S5,$T4>$T5,$Y4>$Y5),"R:T-Y",IF(AND($R4>$R5,$S4>$S5,$T4>$T5),"R:T",IF(AND($U4>$U5,$V4>$V5,$W4>$W5,$X4>$X5,$Y4>$Y5,$Z4>$Z5),"U:Z",IF(AND($U4>$U5,$V4>$V5,$M4>$M5,$S4>$S5,$W4>$W5,$Y4>$Y5),"U:V-M-S-W-Y",IF(AND($U4>$U5,$V4>$V5,$S4>$S5,$W4>$W5,$Y4>$Y5),"U:V-S-W-Y",IF(AND($U4>$U5,$V4>$V5,$W4>$W5,$Y4>$Y5),"U:V-W-Y",IF(AND($U4>$U5,$V4>$V5,$Y4>$Y5),"U:V-Y",IF(AND($U4>$U5,$V4>$V5,$W4>$W5),"U:V-W",""))))))))))))))))))))))))))))))))))))))))))
H8:H9,H4:H6	H4	=IFERROR(IF(AND($A4=$AD4,$AI4>=0.6,$AJ4>=0.6,$AK4>=0.525,$AL4>=0.525,$AH4<$AF$1,$G4<>""),$A4,""),"")
I4:I9	I4	=IF($H4<>"",$B4,"")
AD4	AD4	=IFS($AC4>$AC5,$A4,$AC4<$AC5,"",AND($AC4=0,$AC5=0),"",$AC4=$AC5,"Tie")
AE4:AE9	AE4	=IFERROR(VLOOKUP($A4,$BU$6:$BX$35,4,0),"")
AF4:AF9	AF4	=IFERROR(VLOOKUP(A4,'C:\Users\Greg\Documents\Sports-Wagering\[Wagers.xlsm]NBA'!$N$9:$Q$42,4,0),"")
AG4:AG9	AG4	=IFERROR(INDEX(Injuries!$2:$2,MATCH($A$4:$A$33,Injuries!$1:$1,0)),"")
AH4:AH9	AH4	=IFERROR(INDEX(Injuries!$B$16:$EQ$16,MATCH($A4,Injuries!$B$1:$EQ$1,0)+4),"")
AI4:AI9	AI4	=IF($G4="","",SUMIFS($AR$7:$BL$142,$AN$5:$BH$140,$G4))
AJ4:AJ9	AJ4	=IF($B4>=1,ROUND(VLOOKUP($A4,$DU$6:$DY$35,5,0),2),IF(AND($B4<=-1,$B4>=-4.5),ROUND(VLOOKUP($A4,$DH$6:$DL$35,5,0),2),IF(AND($B4<=-5,$B4>=-9.5),ROUND(VLOOKUP($A4,$CU$6:$CY$35,5,0),2),IF($B4<=-10,ROUND(VLOOKUP($A4,$CH$6:$CL$35,5,0),2),""))))
AK4:AK9	AK4	=IFERROR(ROUND(VLOOKUP($A4,$BU$6:$BX$35,4,0),2),"")
AL4:AL9	AL4	=IFERROR(IF(MOD(ROW(),2)=0,ROUND(VLOOKUP($A4,TeamRankings!$DY$36:$EB$65,4,0),2),ROUND(VLOOKUP($A4,TeamRankings!$DY$3:$EB$32,4,0),2)),"")
AM4:AM9	AM4	=IFERROR(VLOOKUP($A4,TeamRankings!$AT$3:$BC$33,10,0),"")
G5,G9,G7	G5	=IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$W5>$W4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$M5>$M4),"R:Z-M",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$W5>$W4,$X5>$X4,$Y5>$Y4,$Z5>$Z4),"R:Z",IF(AND($M5>$M4,$Q5>$Q4,$R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-Q-R:V-X:Z-W",IF(AND($M5>$M4,$Q5>$Q4,$R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-Q-R:V-Y:Z-W",IF(AND($M5>$M4,$R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-R:V-X:Z-W",IF(AND($M5>$M4,$R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-R:V-Y:Z-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"R:V-X:Z-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"R:V-Y:Z-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$X5>$X4,$Y5>$Y4,$Z5>$Z4),"R:V-X:Z",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Y5>$Y4,$Z5>$Z4),"R:V-Y:Z",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$M5>$M4,$Q5>$Q4,$W5>$W4),"R:V-M-Q-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$M5>$M4,$W5>$W4,$Y5>$Y4),"R:V-M-W-Y",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Q5>$Q4,$W5>$W4),"R:V-Q-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$W5>$W4,$Y5>$Y4),"R:V-W-Y",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Q5>$Q4),"R:V-Q",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$W5>$W4),"R:V-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$Y5>$Y4),"R:V-Y",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4,$M5>$M4),"R:V-M",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$U5>$U4,$V5>$V4),"R:V",IF(AND($M5>$M4,$Q5>$Q4,$R5>$R4,$S5>$S4,$T5>$T4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-Q-R:T-X:Z-W",IF(AND($M5>$M4,$Q5>$Q4,$R5>$R4,$S5>$S4,$T5>$T4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-Q-R:T-Y:Z-W",IF(AND($M5>$M4,$R5>$R4,$S5>$S4,$T5>$T4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-R:T-X:Z-W",IF(AND($M5>$M4,$R5>$R4,$S5>$S4,$T5>$T4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"M-R:T-Y:Z-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$X5>$X4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"R:T-X:Z-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$Y5>$Y4,$Z5>$Z4,$W5>$W4),"R:T-Y:Z-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$X5>$X4,$Y5>$Y4,$Z5>$Z4),"R:T-X:Z",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$Y5>$Y4,$Z5>$Z4),"R:T-Y:Z",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$M5>$M4,$Q5>$Q4,$W5>$W4),"R:T-M-Q-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$M5>$M4,$W5>$W4,$Y5>$Y4),"R:T-M-W-Y",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$Q5>$Q4,$W5>$W4),"R:T-Q-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$J5>$J4,$Y5>$Y4),"R:T-J-Y",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$J5>$J4),"R:T-J",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$M5>$M4),"R:T-M",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$W5>$W4),"R:T-W",IF(AND($R5>$R4,$S5>$S4,$T5>$T4,$Y5>$Y4),"R:T-Y",IF(AND($R5>$R4,$S5>$S4,$T5>$T4),"R:T",IF(AND($U5>$U4,$V5>$V4,$W5>$W4,$X5>$X4,$Y5>$Y4,$Z5>$Z4),"U:Z",IF(AND($U5>$U4,$V5>$V4,$M5>$M4,$S5>$S4,$W5>$W4,$Y5>$Y4),"U:V-M-S-W-Y",IF(AND($U5>$U4,$V5>$V4,$S5>$S4,$W5>$W4,$Y5>$Y4),"U:V-S-W-Y",IF(AND($U5>$U4,$V5>$V4,$W5>$W4,$Y5>$Y4),"U:V-W-Y",IF(AND($U5>$U4,$V5>$V4,$Y5>$Y4),"U:V-Y",IF(AND($U5>$U4,$V5>$V4,$W5>$W4),"U:V-W",""))))))))))))))))))))))))))))))))))))))))))
AD5	AD5	=IFS($AC5>$AC4,$A5,$AC5<$AC4,"",AND($AC5=0,$AC4=0),"",$AC5=$AC4,"Tie")
AD6,AD8	AD6	=IFS($AC6>$AC7,$A6,OR($AC6<$AC7,AND($AC6=0,$AC7=0)),"",$AC6=$AC7,"Tie")
H7	H7	=IF(AND($A7=$AD7,$AI7>=0.6,$AJ7>=0.6,$AK7>=0.525,$AL7>=0.525,$AH7<$AF$1,$G7<>""),$A7,"")
AD7,AD9	AD7	=IFS($AC7>$AC6,$A7,OR($AC7<$AC6,AND($AC7=0,$AC6=0)),"",$AC7=$AC6,"Tie")

 

[jasonb75]

The solution is to correct the source of the error (the formula in AJ) so that it is no longer an error.

The workaround is to error trap the part of the formula that looks at AJ so that it returns TRUE when there is an error.

=IFERROR(IF(AND($A4=$AD4,$AI4>=0.6,IFERROR($AJ4>=0.6,TRUE),$AK4>=0.525,$AL4>=0.525,$AH4<$AF$1,$G4<>""),$A4,""),"")

 

[gtd526]

The solution is to correct the source of the error (the formula in AJ) so that it is no longer an error.

The workaround is to error trap the part of the formula that looks at AJ so that it returns TRUE when there is an error.

=IFERROR(IF(AND($A4=$AD4,$AI4>=0.6,IFERROR($AJ4>=0.6,TRUE),$AK4>=0.525,$AL4>=0.525,$AH4<$AF$1,$G4<>""),$A4,""),"")

I've applied the IFERROR to the remaining ranges in the nestedif statement.
Thank you.