<div>
You can try this:<br />
<br />
1.IFERROR(H6*1,0)*J3*SIGN(<wbr />E6)<br />
<br />
2.IFERROR((H6&amp;C6)*1,0)*J3*<wbr />SIGN(E6)
</div>


<div>
no does not work, because if cell h6= zero or nothing the result must show nothing..
</div>


Your file with completely changed formulas

tiles-wall-floor_1.xlsx

Building Estimator

Frank .S

<div>
thankyou experts for your solutions
</div>


<div>
<div class="content wysiwyg-content">
hi experts, how can i add an IF/OR statement &amp;&nbsp;a IF/OR/AND to the following formula below?<br />
<br />
1_basically if h6 = either nothing or zero qty then do nothing otherwise....<br />
=IF(H6=&quot;&quot;,&quot;&quot;,(H6*J3*SIGN(E<wbr />6)))<br />
<br />
2_basically if h6 &amp;&nbsp;C6= either nothing or zero qty then do nothing otherwise....
</div>
</div>


hi experts, how can i add an IF/OR statement & a IF/OR/AND to the following formula below?

1_basically if h6 = either nothing or zero qty then do nothing otherwise....
=IF(H6="","",(H6*J3*SIGN(E6)))

2_basically if h6 & C6= either nothing or zero qty then do nothing otherwise....

You can try this:

1.IFERROR(H6*1,0)*J3*SIGN(E6)

2.IFERROR((H6&amp;amp;C6)*1,0)*J3*SIGN(E6)

no does not work, because if cell h6= zero or nothing the result must show nothing..

IF/OR statement &amp;amp; IF/OR/AND statement

hi experts, how can i add an IF/OR statement &amp;amp; a IF/OR/AND to the following formula below?

1_basically if h6 = either nothing or zero qty then do nothing otherwise....
=IF(H6=&amp;quot;&amp;quot;,&amp;quot;&amp;quot;,(H6*J3*SIGN(E6)))

2_basically if h6 &amp;amp; C6= either nothing or zero qty then do nothing otherwise....

IF/OR statement &amp; IF/OR/AND statement

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.