Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 451
  • Last Modified:

Leave Cell Blank in Excel

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)?
0
Mark Grondin
Asked:
Mark Grondin
1 Solution
 
Vipin KumarSr. Network EngineerCommented:
The syntax that you can use is:

IF(SUM(A1+A2)>0,SUM(A1+A2),"")
0
 
Mark GrondinAuthor Commented:
So simple, should have thought of that...
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now