<div>
Rodney, thank you for the detailed explanation. I really appreciate your help!
</div>


Rodney, thank you for the detailed explanation. I really appreciate your help!

<div>
No problem, fjkaykr11, glad I can help.
</div>


<div>
<div class="content wysiwyg-content">
In Excel 2010, I am viewing a spreadsheet that contains an IF statement (below are the details)<br />
<br />
Cell B4 contains Sales 2013<br />
Cell B5 contains Sales 2014<br />
<br />
In Cell B6 the formula contains =IF(B5=&quot;&quot;,&quot;&quot;,(B4-B5)B5)<br />
<br />
I am not familiar with part of the formula that indicates: &nbsp;B5=&quot;&quot;,&quot;&quot;, <br />
<br />
Any feedback is greatly appreciated, Thanks.
</div>
</div>


In Excel 2010, I am viewing a spreadsheet that contains an IF statement (below are the details)

Cell B4 contains Sales 2013
Cell B5 contains Sales 2014

In Cell B6 the formula contains =IF(B5="","",(B4-B5)B5)

I am not familiar with part of the formula that indicates:  B5="","", 

Any feedback is greatly appreciated, Thanks.

Excel IF 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.