LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Can I formulaically set a cell to blank (non-Text, no value)?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? PaulH_1980 Excel Worksheet Functions 1 March 15th 06 11:51 PM
Shade cell according to text? Ltat42a Excel Discussion (Misc queries) 0 January 3rd 06 06:37 PM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
adding a formula in a cell but when cell = 0 cell is blank Mike T Excel Worksheet Functions 5 May 31st 05 01:08 AM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"