How to assign a cell the "empty" value?

[xirx]

Hi!

I want to assign some value to a cell if some condition
is fulfilled. But if the condition is not true, I want
the cell to be empty.

But if I use a formla like this...

IF(<Condition>;<value>;"")

.... the cell gets the zero-length string value, which
is *NOT* identical to an empty cell, because if I
use CRTL-<up/down-arrow> to skip to the next non-empty
cell, a cell with value "" is a non-empty cell.

So, is there a way to clear a cells value by an assigngment?

 

[Peo Sjoblom]

No, you would need an event macro to truly make it empty, if this is for a
chart
you can replace the "" with NA() and it will be as if it was empty and not
zero
You can also use formulas to determine where the last cell with either a
text or numeric
string is located

 

[Herbert Seidenberg]

Use
=IF(<Condition>,<value>)
instead, then select vector and
Edit>Goto>Special>Formulas>Logicals
Clear Contents