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
<tbody>
</tbody>
all cells are with general formatting
a1
590_310814
b1
=IF(RIGHT(A1,4)>2000,"x")
result in B1
x
a | b | c | d | e | |
1 | 590_310814 | =IF(RIGHT(A1,4)>2000,"x","z") | |||
2 |
<tbody>
</tbody>