<div>
So simple, should have thought of that...
</div>


<div>
<div class="content wysiwyg-content">
I would like to have an &quot;if&quot; formula that gives me a calculation if numbers in the cells meet a criteria (e.g. sum to greater than 0) and leaves the cell blank if they do not.<br />
<br />
Here is an example: <br />
if(A1+A2&gt;0, A1+A2, {formula to leave cell blank})<br />
<br />
What would be the syntax I could use to leave a cell blank (meaning not a 0, but actually leave it without a value)?
</div>
</div>


I would like to have an "if" formula that gives me a calculation if numbers in the cells meet a criteria (e.g. sum to greater than 0) and leaves the cell blank if they do not.

Here is an example: 
if(A1+A2>0, A1+A2, {formula to leave cell blank})

What would be the syntax I could use to leave a cell blank (meaning not a 0, but actually leave it without a value)?

Leave Cell Blank in Excel

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