inserting a null value

T

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
 
F

Fred Smith

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

Regards,
Fred.
 
G

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
 
Top