setting a cell to null

  • Thread starter Thread starter simon may
  • Start date Start date
S

simon may

Is there a way to set a cells value to null with an if
statement? for example ...

=if(a1="yes",1,NULL)

.... so that if a1 does not equal 1 the cell stays as null.

if i change the formula to read ...

=if(a1="yes",1,"")

.... the cell appears empty but it no responds to funtions
that work with blank cells LIKE countblank() or isblank().
 
No you can't do that with an IF statement, if this is for graphing you can
create pseudo null by using

=IF(A1="yes",1,NA())

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top