Building Estimator

Frank .S

Gustav Brock

<div>
<p>Hi Frank</p><p><br></p><p>Where is your quantity.</p><p><br></p><p>If you define your quantity in E7, and if it is negative, use this formula.</p><p><br></p><p>=IF(E7&lt;0, ABS(ROUNDDOWN(H7*J3,0)), H7*J3)</p><p><br></p>
</div>


<div>
hi kesavan, your formula does not work for me... please recheck
</div>


<div>
<div class="content wysiwyg-content">
hi experts the following ifstatement in cell J7 is not calculating correctly, please give me a solution <br />
- should = h7*j3 (round down because is a negative qty) therefore -45 x 0.03= 1.35 rounded down to 1.00<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/02_w07/1443914/ifstatement-not-calculating-correctl.PNG" target="_blank" title="ifstatement not calculating correctly - 1 (20 KB)"><img alt="ifstatement not calculating correctly - 1" class="file-block lazyload" style="max-width: 621px;" data-src="https://filedb.experts-exchange.com/incoming/2020/02_w07/1443914/ifstatement-not-calculating-correctl.PNG" /></a>
</div>
</div>


ifstatement not calculating correctly - 1

ifstatement-not-calculating-correctl.PNG

hi experts the following ifstatement in cell J7 is not calculating correctly, please give me a solution 
- should = h7*j3 (round down because is a negative qty) therefore -45 x 0.03= 1.35 rounded down to 1.00




if statement rounddown formula result not calculating correctly

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.