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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Excel Need Countifs Formula Help 0
IF Function -- Return Null Value Help 2
IF statement to check for numerical value 3
Inserting "true" blanks with functions 5
Sum a NULL cell 6
How do I put a blank value in a cell not using "" in a formula 2
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top