inserting a null value
 

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

inserting a null value
 

Hi,

What is a null value?

=IF(A1=0,"NULL",A1*20)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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

inserting a null value
 

Null to Excel is "", so your formula would be:
=if(a1=0,"",a1*20)

Regards,
Fred.

"Todd" wrote in message
...
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

inserting a null value
 

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