Thread: How do I get Null as a result of an if?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default How do I get Null as a result of an if?
wrote..
=if(false, "yup",) will record 0
=if(false, "yup","") will record the empty string
=if(false, "yup") will record "False"

What I want is null, nothing, nada. rien de tout, a virgin cell.

Well, you ain't gonna get it!

There is no "null". The closest you can get is the empty string

Biff


Reply With QuoteReply With Quote