What is the Null character?
 

What is the character sequence that Excel uses to represent an empty cell? I
am using a formula and when it returns false, I would like for it to
represent the cell as if it was empty. I have tried using "" as an empty
cell, but excel recognizes that this is a value, not an empty cell.

You can't do what you want to do. A formula always returns
*something*.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Quinn Ramsey" <Quinn wrote in
message
...
What is the character sequence that Excel uses to represent an
empty cell? I
am using a formula and when it returns false, I would like for
it to
represent the cell as if it was empty. I have tried using ""
as an empty
cell, but excel recognizes that this is a value, not an empty
cell.

If this is causing you a problem because you're trying to use COUNTA on the
results of the IF function adjust your COUNTA expression so that it becomes
=COUNTA(Range)-COUNTBLANK(Range) this will deduct the cells containing the "".

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Quinn Ramsey" wrote:

What is the character sequence that Excel uses to represent an empty cell? I
am using a formula and when it returns false, I would like for it to
represent the cell as if it was empty. I have tried using "" as an empty
cell, but excel recognizes that this is a value, not an empty cell.

To pick up the original question of the excel <null character, I am trying
to run a graph off a set of data and would like it to read <null as a result
of the formula (so it doesnt plot the entry). If "" is used it reads this as
'0' which is not what is required. Can someone please suggest if there is any
way to return <null?
Tks

"Andrea Jones" wrote:

If this is causing you a problem because you're trying to use COUNTA on the
results of the IF function adjust your COUNTA expression so that it becomes
=COUNTA(Range)-COUNTBLANK(Range) this will deduct the cells containing the "".

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Quinn Ramsey" wrote:

What is the character sequence that Excel uses to represent an empty cell? I
am using a formula and when it returns false, I would like for it to
represent the cell as if it was empty. I have tried using "" as an empty
cell, but excel recognizes that this is a value, not an empty cell.

What is the Null character?
 

How does one suggest to the Excel development team that they correct this
glaring limitation?

David C. Ziemer

"Chip Pearson" wrote:

You can't do what you want to do. A formula always returns
*something*.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Quinn Ramsey" <Quinn wrote in
message
...
What is the character sequence that Excel uses to represent an
empty cell? I
am using a formula and when it returns false, I would like for
it to
represent the cell as if it was empty. I have tried using ""
as an empty
cell, but excel recognizes that this is a value, not an empty
cell.

What is the Null character?
 

If a cell contains a formula, how can it at the same time, appear to be
empty?
Bill Gates and crew are not magicians
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"D Ziemer" <D wrote in message
...
How does one suggest to the Excel development team that they correct this
glaring limitation?

David C. Ziemer

"Chip Pearson" wrote:

You can't do what you want to do. A formula always returns
*something*.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Quinn Ramsey" <Quinn wrote in
message
...
What is the character sequence that Excel uses to represent an
empty cell? I
am using a formula and when it returns false, I would like for
it to
represent the cell as if it was empty. I have tried using ""
as an empty
cell, but excel recognizes that this is a value, not an empty
cell.