Search : in
By :

Excel: Empty cell in 2007

Last answer on Sep 29, 2009 10:57:29 pm BST RT, on Mar 22, 2009 6:50:44 am GMT 
 Report this message to moderators

Hello,
When presenting raw of data into a chart there is an option to present empty gaps as zero, gaps or connect the dots. none of teh option is working for me.
If i would like to use this forume: =if((sum(a1:a5))=0,"",(sum(a1:a5)))
whats should i put instead of the "" as it does not defined the cell as empty

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Excel: Empty cell in 2007 » in :
Moving data to the next empty cell Show
[Excel]changing cell formula to text Show [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Excel vb find blank cells replace with calc (Solved) Show
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

PicaPica, on Apr 18, 2009 4:51:43 am BST
  • +1

Did you find an answer?
I have the same problem.
Inan IF-function, I do not know which empty result would make an empty cell.

   
Reply to PicaPica

2

Popz, on May 4, 2009 4:43:14 am BST

I had the same problem but the 1st person to post figured out the answer accidently,

=if((sum(a1:a5))=0,"",(sum(a1:a5))) is WRONG

=if((sum(a1:a5))=0," ",(sum(a1:a5))) is RIGHT

i put in the exact formula as him but put " " instead of "" and it works

   
Reply to Popz

3

CF, on May 28, 2009 6:37:10 pm BST

If you put #N/A instead of "" excel won't show anything in your chart. Looks ugly in the source data, but pretty in the chart!

   
Reply to CF

4

mubashir aziz, on May 29, 2009 3:32:47 am BST

You just use NA() function and excel chart will treat it as empty cell ..... then you can hide it in printing by File > Page Setup > Sheet > Cell Error <Blank> ...

You can hide Error values by conditional formating by putting this formula =+ISNA(C5) suppose values are in C5 ......

So your formula is

=if((sum(a1:a5))=0,NA(),(sum(a1:a5)))

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

5

 Nate, on Sep 29, 2009 10:57:29 pm BST

Y E S ! ! !

Brilliant ! I've been struggling with this since yesterday, awesome stuff.

(I used the #N/A method - it still seemed to count " " as Zero)


Ta - Nathan.

   
Reply to Nate
Ask your question Reply
They need your help