811 votes145 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.
John [MS XL]
An error occurred while saving the commentAnonymous commented
It seems to me the latest comment by Microsoft development team intends to tell us why we don't need this null() function and can rely instead on what's already in Excel. As an initial Excel 1.3 user (yes excel 1.3 was for mac, maybe 20 ago or so), I believe I should be capable to do what the developers tell us. If the developers just tell me.
So please, developers, tell us: How do I do when I create a table where lines are records, and there can be many of them, and I plug in an intermediate result column a calculation result stating the price for something belonging to the line. But I want the cell to appear blank, rather than containing an ugly 0 if the line est not yet in use.
Today,when I want lt plug in such intermediate result cell and want such cell to be blank,I set in this cell that the result is "" if my test cel in this linel is blank. The test cell contains data if the line is in use, and nothing if the line is not yet in use.
This fails miserably when I want to use this intermediate result cell in a further calculation, because "" is not blank and Excel does not believe that it contains a 0. It just is not 0. So the calculation using a "" cell fails, in Excel. Bad luck.
So I plug in a 0 instead of a "" and state that the price format in this cell is price for accountants. Hence the cell will contain - instead of 0 if the calculation result is indeed 0. That works in further calculations, but is not a blank cell. It is ugly.
I want a blank cell, not a lousy - .
Excel developers, please tell me How to do without a null() result to my calculation.
Thanks.Anonymous supported this idea ·