<div>
Something like this should do the trick for you..<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-38744590-1"><span>=IF(B2&gt;0,B2,IF(C2&gt;0,C2,IF(D2&gt;0,D2)))</span>
</code></pre>
<br />
HTH,<br />
<br />
Kent
</div>


<div>
<div class="content wysiwyg-content">
I'm using Excel 2007 in a Windows enviroment. Comparing three cells B2 thru D2 need the first value that exceeds 0 starting with B2 then C2 then D2 to be the value of K2. What's the formula I need? Thanks
</div>
</div>


I'm using Excel 2007 in a Windows enviroment. Comparing three cells B2 thru D2 need the first value that exceeds 0 starting with B2 then C2 then D2 to be the value of K2. What's the formula I need? Thanks

Comparing three cells B2 thru D2 need the first value that exceeds 0 to be the value of K2. What's the formula I need?

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