inserting a null value

[Todd]

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

 

[Shane Devenshire]

Hi,

What is a null value?

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

 

[Fred Smith]

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

Regards,
Fred.

 

[Gord Dibben]

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