View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] chris.cudmore@gmail.com is offline
external usenet poster
 
Posts: 13
Default How do I get Null as a result of an if?

=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.