Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tosh
 
Posts: n/a
Default how do i create a blank cell in excel using a formula

if i use "" in an IF formula, then it generates a cell which looks empty.
however, when i then use the data series to generate a scatter graph, my
whole series disppears, including the cells which contain numeric data.

is there another way of creating a blank cell through use of a formula?

Thank you
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

I've heard that the #N/A error works well in this context.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Tosh" wrote in message
...
if i use "" in an IF formula, then it generates a cell which looks empty.
however, when i then use the data series to generate a scatter graph, my
whole series disppears, including the cells which contain numeric data.

is there another way of creating a blank cell through use of a formula?

Thank you


Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
display negative values as a blank cell in Excel pherozeb Excel Discussion (Misc queries) 3 January 5th 05 05:40 AM
display negative values as a blank cell in Excel Pheroze Bharucha Excel Discussion (Misc queries) 0 January 4th 05 11:51 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 09:21 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 02:03 PM.

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

About Us

"It's about Microsoft Excel"