<div>
<div class="content wysiwyg-content">
hi experts i would like some help with this formula please<br />
<br />
=IF(C14=&quot;&quot;,&quot;&quot;,D14*E14*F14)<wbr /><br />
<br />
what i need here is an addition to this formula, whereby if there is no value in f14, i want the result to = just d14xe14.<br />
The logic to this fyi is that this table is set to a volume calc where by there is a length x width x depth, so that i dont have to creat a separate table for an area calculation i just want the result dxe instead?<br />
<br />
please assist
</div>
</div>


hi experts i would like some help with this formula please

=IF(C14="","",D14*E14*F14)

what i need here is an addition to this formula, whereby if there is no value in f14, i want the result to = just d14xe14.
The logic to this fyi is that this table is set to a volume calc where by there is a length x width x depth, so that i dont have to creat a separate table for an area calculation i just want the result dxe instead?

please assist

if formula - calc &amp; masterwksht

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

if formula - calc &amp; masterwksht

if formula - calc & masterwksht