Can I insert a null value based on IF condition?

External Since: Sep 20, 2005 Posts: 1

Can I insert a null value into a cell based on IF true or false condition?

Thanks for your feedback!

External Since: Sep 12, 2003 Posts: 37

"Frank Xia" <FrankXia DeleteThis @discussions.microsoft.com>
wrote in message
news:C5508BD0-549A-44D3-A8BA-1FA60CB1E834@microsoft.com...
>
> Can I insert a null value into a cell based on IF true or false
> condition?
>
> Thanks for your feedback!
>

Hi Frank,

Unfortunately there is no way of returning a null value from a
formula.

The closest options you can get include:

1) Empty string ("")

2) Zero

3) Not applicable (#N/A or NA())

There are probably other options, but those are the ones I tend to use
most often.

It is a major ommission from excel!

HTH,

Alan.