Need help: compare two cells for highest number, if text in one of the cell then return N/A

[bb19august]

Need help with the following

if B>A result Y, if A>B result N, if text in any of the cell then result is N/A

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C (Result)[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]100[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD]10[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]zero[/TD]
[TD]100[/TD]
[TD]N/A[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 136"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you

 

[Aryatect]

Hi, below should work, there are 2 options from my side 1 array in Col M and 1 regular in Col N:

Book1
	K	L	M	N
1	A	B	C (Result) - Array	C (Result)- Regular
2	5	4	N	N
3	10	100	Y	Y
4	N/A	10	N/A	N/A
5	zero	100	N/A	N/A
Sheet3

Cell Formulas
Range	Formula
N2	=IF(AND(ISNUMBER(K2),ISNUMBER(L2)),IF(K2>L2,"N","Y"),"N/A")
M2	{=IF(ISNUMBER(K2:L2),IF(K2>L2,"N","Y"),"N/A")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Rick Rothstein]

Here is one way...

=IFERROR(IF(-B1>-A1,"N","Y"),"N/A")

 

[Aryatect]

another:

Book1
	M
2	N
Sheet3

Cell Formulas
Range	Formula
M2	=IF(ISERROR(K2*L2),"N/A",IF(K2>L2,"N","Y"))

 

[bb19august]

Here is one way...

=IFERROR(IF(-B1>-A1,"N","Y"),"N/A")

Thank you Rick. looks like you can solve these kind of tough ones (at least for me) in a matter of mico-seconds.

 

[bb19august]

another:

	M
N

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M2[/TH]
[TD="align: left"]=IF(ISERROR(K2*L2),"N/A",IF(K2>L2,"N","Y"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you Aryatect. all your options work. I tried with ISNUMBER for an hour without any success.

 

[Aryatect]

Glad could help. After I posted I checked @Rick Rothstein formula, it is the shortest one