=IF($E14="","",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14))

<div>
The condition $E14=&quot;&quot; will be evaluated to be False if E14 is 0 but the condition $E14=0 will be evaluated to be True if the E14 is either blank or contains 0. So checking $E14=0 only is more than enough.<br />
<br />
You may rewrite your formula as below...<br />

<pre><code id="code-20-42682541-1">=IF($E14=0,&quot;&quot;,IF($Z14=&quot;&quot;,$T14/1/$K14,$T14/$Z14/$K14))</code></pre>
</div>


The condition $E14="" will be evaluated to be False if E14 is 0 but the condition $E14=0 will be evaluated to be True if the E14 is either blank or contains 0. So checking $E14=0 only is more than enough.

You may rewrite your formula as below...


=IF($E14=0,"",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14))

Svgmassive

<div>
<div class="content wysiwyg-content">
I am looking for a more efficient function,Any suggestions?<br />
=IF($E14=&quot;&quot;,&quot;&quot;,IF($E14=0,&quot;<wbr />&quot;,IF($Z14=<wbr />&quot;&quot;,$T14/1/<wbr />$K14,$T14/<wbr />$Z14/$K14)<wbr />))<br />
Thanks
</div>
</div>


I am looking for a more efficient function,Any suggestions?
=IF($E14="","",IF($E14=0,"",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14)))
Thanks

More Efficient Formula

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.