Excel IF statement Comparing text with number
<p>I was using <code>IF</code> statement to group some numbers together.
In column <code>A</code> I have numeric and text values.</p>

<pre><code>  A   B
1 s   =IF(A1&gt;200,2345,"ad")
</code></pre>

<p>If I do this then the <code>B1</code> returns <code>2345</code>. </p>

<p>How does Excel compare string values with number values?</p>