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

A	B	C (Result)
5	4	N
10	100	Y
N/A	10	N/A
zero	100	N/A

<tbody>
</tbody>

<tbody>
</tbody>

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
2	N

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula M2 =IF(ISERROR(K2*L2),"N/A",IF(K2>L2,"N","Y")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

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