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

[bb19august]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E (RESULT)

[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]Y[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]N[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"]N/A[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]N/A[/TD]
[/TR]
</tbody>[/TABLE]

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.