Excel Formula - compare two set of cells and find return the result based on the logic

[bb19august]

	A	B	C	D	E (RESULT)
1	10	10	5	50	Y
2	20	20	1	1	N
3	10	10	N/A	N/A	N/A
4	N/A	N/A	2	3	N/A

<tbody>
</tbody>

Need help with this as well.
Logic : C>A OR D>B = Y else N
if N/A present in A&B or C&D then result is N/A

 

[Eric W]

Try:

=IF(COUNTIF(A1:D1,"N/A"),"N/A",IF(OR(C1>A1,D1>B1),"Y","N"))

 

[bb19august]

Try:

=IF(COUNTIF(A1:D1,"N/A"),"N/A",IF(OR(C1>A1,D1>B1),"Y","N"))

It works as expected. Thank you.
If incase the four numbers are not in A, B, C and D columns. first two numbers are in column A and B and second two numbers are in F and G, how can we update the above formula?

 

[Eric W]

Possibly:

=IF(OR(A1="N/A",B1="N/A",F1="N/A",G1="N/A"),"N/A",IF(OR(F1>A1,G1>B1),"Y","N"))

or to borrow from Rick's construction in the other thread:

=IFERROR(IF(OR(-F1<-A1,-G1<-B1),"Y","N"),"N/A")

 

[bb19august]

Thank you so much Eric.