How to assign a cell the "empty" value?

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?

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

--

Regards,

Peo Sjoblom


"xirx" <[email protected]> wrote in message
news:[email protected]...
> 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?

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