<div>
Like this?<br />
=IF(COUNT(C10:C99)&gt;0, B2, &quot;&quot;)
</div>


<div>
<pre><code id="code-20-41935246-1">=IF(VALUE(C1);B1;&quot;&quot;)</code></pre>
</div>


<div>
Misunderstood question, above comment from Shaun Kline definitely the easiest method
</div>


Misunderstood question, above comment from Shaun Kline definitely the easiest method

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I need an If statement (or any other statement) that says when cell C10 thru C99 &nbsp;has a value (neg, positive or $0), return the value in cell B2. &nbsp;I hope this makes sense.
</div>
</div>


Hi, 

I need an If statement (or any other statement) that says when cell C10 thru C99  has a value (neg, positive or $0), return the value in cell B2.  I hope this makes sense.

Excel If Statement to return a value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.