No such function in Excel.

NULL is nothing.

You cannot truly have a NULL cell if it contains a formula.



Gord Dibben MS Excel MVP


On Tue, 30 Jun 2009 13:15:01 -0700, Todd
wrote:

is it possible to insert a null value into a cell instead of a blank ("") in
an IF function.

=if(A1=0,NULL,A1*20) ...... something like this?

Any help is greatly appreciated