Excel wrong comparison after numbers extraction with if(right(

[exbuddy]

What I am doing wrong here? does value 0814 greater than 2000? I need result {z} in cell B1.
all cells are with general formatting
a1
590_310814

b1
=IF(RIGHT(A1,4)>2000,"x")

result in B1
x

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]590_310814[/TD]
[TD]=IF(RIGHT(A1,4)>2000,"x","z")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Comfy]

Try:

=IF(VALUE(RIGHT(A1,4))>2000,"x","z")

 

[VoG]

Try

=IF(RIGHT(A1,4)+0>2000,"x")

 

[exbuddy]

issue solved. Thanks Comfy and VoG. Both examples are valid.



[TABLE="class: cms_table_grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]590_310814[/TD]
[TD]=IF(VALUE(RIGHT(A1,4))>2000,"x","z")
and
=IF(RIGHT(A1,4)+0>2000,"x","z")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #FAFAFA"]2[/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[/TR]
</tbody>[/TABLE]