setting a cell to null

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().
 
P

Peo Sjoblom

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)
 

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
If Statement in Database Query 0
If Not blank - Formula for two cells 0
IF statement to check for numerical value 3
Excel does not accept text format! 0
Inserting "true" blanks with functions 5
Referencing the values of multiple cells in conditinal formatting. 0
How do I put a blank value in a cell not using "" in a formula 2

Top