Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Creating blank cells in excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Creating blank cells in excel

Reply to Message Icon

Name: psandwich
Date: March 9, 2004 at 02:35:15 Pacific
OS: windows NT
CPU/Ram: pentium, 256 mb
Comment:

Hello,

Does anyone know how to make Excel treat a cell as blank if there is a formula in it?

I have a formula which puts the contents of one cell into another
=IF((Y4>5),"",X4)

In some cases the reference cell is blank so no value is entered into the cell.

However, when I plot a chart of this data, the empty cells are plotted as zero.

Is there a way to have the empty cells *not* plotted? As I would rather have gaps in the graph, or interpolate between missing values.

I know that if you go to tools>options>chart you can select how to represent blank cells in a chart. My problem is creating the blank cell in the first place.

Any help would be totally appreciated.

Thanks!

ps



Sponsored Link
Ads by Google

Response Number 1
Name: psandwich
Date: March 9, 2004 at 05:30:42 Pacific
Reply:

Turns out its:
=IF((Y4>5),NA(),L4)

I thought I better put the answer up in case someone else had the same problem.

Thanks anyway!:)


0

Response Number 2
Name: Report_2
Date: March 9, 2004 at 15:00:45 Pacific
Reply:

Thanks.
Bryan


0

Response Number 3
Name: Report_2
Date: March 9, 2004 at 15:15:23 Pacific
Reply:

I just tried it and it produced #NA in the cell. I wonder what I did wrong?

Bryan


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Creating blank cells in excel
How to create combo box in excel www.computing.net/answers/office/how-to-create-combo-box-in-excel/8048.html

Cannot merge cells in excel www.computing.net/answers/office/cannot-merge-cells-in-excel/1622.html

Removing Blank cells in pulldown menu www.computing.net/answers/office/removing-blank-cells-in-pulldown-menu/9098.html