I think I have a similar question, maybe it could help us both.
I use a formula to populate column B under the condition column A is greater than 0. I want column B to not display 0 or - or #NA so I use this:
I later chart this column for multiple sheets. The really odd thing is that sometimes the charts don't drop to zero in the 'Else if' situation, but sometimes they do....
Is there an alternative to "" and NA() that effectively makes a cell NILL without displaying anything?
Maybe I could make a custom formula as a macro say called "Nill()" and when I put that into a cell it makes it blank? I don't know how this could work though since I still want to keep the IF() statement there.
Bookmarks