Tom M

<div>
<p>These are the kind of formulas that Norie was suggesting:</p><p><br></p><p>If you want to return "Y" when J2 contains an error value:</p><pre><code class="code-1 nolinks" id="code-20-43544047-1">=IFERROR(IF(OR(B2&gt;0,J2="Y"),"Y","Janet"),"Y")</code></pre><p><br></p><p>If you want to return "Janet" when J2 contains an error value:</p><pre><code class="code-1 nolinks" id="code-20-43544047-2">=IFERROR(IF(OR(B2&gt;0,J2="Y"),"Y","Janet"),"Janet")</code></pre><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>What have i done wrong with the formula in cell f2? &nbsp;B2 is greater than 0 so i should be getting Y in cell f2 &nbsp;&nbsp;<a class="fr-file" href="https://filedb.experts-exchange.com/incoming/2023/06_w25/1620426/Book1.xlsx" rel="ugc">Book1.xlsx</a></p>
</div>
</div>


Book1.xlsx


What have i done wrong with the formula in cell f2?  B2 is greater than 0 so i should be getting Y in cell f2   
Book1.xlsx


These are the kind of formulas that Norie was suggesting:
If you want to return &quot;Y&quot; when J2 contains an error value:
=IFERROR(IF(OR(B2&gt;0,J2=&quot;Y&quot;),&quot;Y&quot;,&quot;Janet&quot;),&quot;Y&quot;)
If you want to return &quot;Janet&quot; when J2 contains an error value:
=IFERROR(IF(OR(B2&gt;0,J2=&quot;Y&quot;),&quot;Y&quot;,&quot;Janet&quot;),&quot;Janet&quot;)

if statement with or

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.