<div>
use isblank() method<br />
<br />
=IF(ISBLANK(A1);&quot;&quot;;A1*B1)
</div>


use isblank() method

=IF(ISBLANK(A1);"";A1*B1)

<div>
@LazyFold<br />
<br />
Lets assume that cell A1 also contains a formula in it like =IF(D1=&quot;&quot;,&quot;&quot;,D1) OR =IF(ISBLANK(D1),&quot;&quot;,D1) &nbsp;and suppose D1 is blank or empty and as a result A1 would also be blank, in that case what do you expect your formula to return?
</div>


@LazyFold

Lets assume that cell A1 also contains a formula in it like =IF(D1="","",D1) OR =IF(ISBLANK(D1),"",D1)  and suppose D1 is blank or empty and as a result A1 would also be blank, in that case what do you expect your formula to return?

<div>
Works a treat and superfast response
</div>


<div>
<div class="content wysiwyg-content">
Need help with an if statement<br />
Have 3 cells , A B &nbsp;C<br />
Looking for:- formula in cell C<br />
If cell A is blank then cell C is blank<br />
Else if cell A has a value then cell A multiplied by Cell B
</div>
</div>


Need help with an if statement
Have 3 cells , A B  C
Looking for:- formula in cell C
If cell A is blank then cell C is blank
Else if cell A has a value then cell A multiplied by Cell B

Excel formula

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.

Microsoft Office

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