Adding OR criteria to IF statement

[miva0601]

Hello,

I'm trying to add an additional OR condition to the below statement. If column G starts with a '4' or '7', then it should be treated same as the when the district starts with a '3'. Greatly appreciate anyone who can help me figure this out. I've tried adding this as another IF condition but think OR might cleaner.

Both BY7 and BY8 should say 'Yes"

Admin Fee D- Test.xlsx
	A	B	C	D	E	F	G																																																																		BU	BV	BW	BX	BY
1	DC	DC Name	Customer	Customer Name	SAMPLE	CATEGORY	District																																																																		CRITERIA	Adjusted BPR	Adjusted GPR	Adjusted GCR	Highly Compliant?
2	321	A	1234	AA	A	1	101100																																																																		Y	101.230	84.000	0.000	No
3	213	B	12345	BB	B	2	301100																																																																		Y	90	90	24.000	Yes
4	142	C	123456	CC	C	3	311100																																																																		Y	100.000	79.000	15.000	No
5	234	D	1234567	DD	D	4	111100																																																																		Y	90.230	87.430	0.000	No
6	456	E	144246	EE	E	5	111100																																																																		Y	94.000	90.000	0.000	Yes
7	658	F	3216	FF	F	6	701100																																																																		Y	99.040	95.010	30.000	No
8	789	G	35486	GG	G	7	401100																																																																		Y	100.000	122.000	40.000	No
VariaVM

Cell Formulas
Range	Formula
BY2:BY8	BY2	=IFERROR(IF(VALUE(LEFT(G2,1))=1,IF(AND(BU2="Y",BV2>=90,BW2>=90),"Yes","No"),IF(VALUE(LEFT(G2,1))=3,IF(AND(BU2="Y",BX2>=24),"Yes","No"),"No")),IF(G2="Not Assigned",IF(AND(BU2="Y",BV2>=90,BW2>=90),"Yes","No"),"Review"))

 

[Fluff]

How about

=IFERROR(IF(VALUE(LEFT(G2,1))=1,IF(AND(BU2="Y",BV2>=90,BW2>=90),"Yes","No"),IF(OR(LEFT(G2)+0={3,4,7}),IF(AND(BU2="Y",BX2>=24),"Yes","No"),"No")),IF(G2="Not Assigned",IF(AND(BU2="Y",BV2>=90,BW2>=90),"Yes","No"),"Review"))