Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
if a1 = null then a1 = b1...how do I do this? | Excel Discussion (Misc queries) | |||
cell value based on null/not null in another cell | Excel Worksheet Functions | |||
When value is NOT Null | Excel Worksheet Functions |