What is the Null character?

Q

Quinn Ramsey

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.
 
R

Redstar11

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
 
D

D Ziemer

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

David C. Ziemer
 
B

Bernard Liengme

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
 
Top