Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
There is an old post from 2003 with the same heading - you may wish to
have a look at the responses there as well. I am trying to make the value of a cell blank as the result of a formula: eg: =if(a13,BLANK,a2-a3) If I use "" or nothing at all, I get a text value or 0 which when graphed will graph as 0. I want these cells to be blank, so that if they are referenced in a graph (or chart) they don't plot on the graph at all. At the moment they are plotting as 0. Any suggestions besides a macro which I think is overkill for my purposes? Thanks and Kind regards Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions |