How to assign a cell the "empty" value?

  • Thread starter Thread starter xirx
  • Start date Start date
X

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?
 
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
 
Use
=IF(<Condition>,<value>)
instead, then select vector and
Edit>Goto>Special>Formulas>Logicals
Clear Contents
 
Back
Top