LinkBack URL
About LinkBacks
If A1+A2>0, this cell displays A1+A2,
else
this cell shows nothing (not 0, not " ", not "N/A", but NOTHING)
Conditionally add contents to a cell, with "Null" option?
If A1+A2>0, this cell displays A1+A2,
else
this cell shows nothing (not 0, not " ", not "N/A", but NOTHING)
Try:
=IF(A1+A2>0,A1+A2,"")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
One would THINK that'd work, but it does not for me.
I need the cell to act "empty"
(Use is for a chart... I want some cells to yield nothing, not "0" (or effectively 0)
Nothing - break in the chart line
"" - line drops to the bottom....
Try returning an #N/A result instead... I think the chart will break the line...Originally Posted by everseeker
One would THINK that'd work, but it does not for me.
I need the cell to act "empty"
(Use is for a chart... I want some cells to yield nothing, not "0" (or effectively 0)
Nothing - break in the chart line
"" - line drops to the bottom....
=IF(A1+A2>0,A1+A2,NA())
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks