Link to home
Start Free TrialLog in
Avatar of Mark Grondin
Mark GrondinFlag for United States of America

asked on

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)?
ASKER CERTIFIED SOLUTION
Avatar of Vipin Kumar
Vipin Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Grondin

ASKER

So simple, should have thought of that...