Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ISNULL function - can't find it
I can't find the ISNULL function. I'm using Office 2003 Small Business
Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
#2
|
|||
|
|||
Hi
do you mean ISEMPTY -- Regards Frank Kabel Frankfurt, Germany "KitKat" schrieb im Newsbeitrag ... I can't find the ISNULL function. I'm using Office 2003 Small Business Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
#3
|
|||
|
|||
There is no ISNULL function except for VBA, maybe you meant ISBLANK?
Regards, Peo Sjoblom "KitKat" wrote: I can't find the ISNULL function. I'm using Office 2003 Small Business Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
#4
|
|||
|
|||
Nope, I mean ISNULL. The version of Excel I used it with was Office 2000
Professional. "Frank Kabel" wrote: Hi do you mean ISEMPTY -- Regards Frank Kabel Frankfurt, Germany "KitKat" schrieb im Newsbeitrag ... I can't find the ISNULL function. I'm using Office 2003 Small Business Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
#5
|
|||
|
|||
Hi
there's no such function in Excel. I was incorrect myself :-) ISBLANK checks for an empty cell. What do you want to achieve with this function? -- Regards Frank Kabel Frankfurt, Germany "KitKat" schrieb im Newsbeitrag ... Nope, I mean ISNULL. The version of Excel I used it with was Office 2000 Professional. "Frank Kabel" wrote: Hi do you mean ISEMPTY -- Regards Frank Kabel Frankfurt, Germany "KitKat" schrieb im Newsbeitrag ... I can't find the ISNULL function. I'm using Office 2003 Small Business Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
#6
|
|||
|
|||
InNull is a VBA function and can be used in code. It can't be used in a
worksheet formula. -- George Nicholson Remove 'Junk' from return address. "KitKat" wrote in message ... I can't find the ISNULL function. I'm using Office 2003 Small Business Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
#7
|
|||
|
|||
IsNull() is a VBA function. There is no null worksheet value in any
version of Excel. The closest worksheet function is ISBLANK(). Jerry KitKat wrote: I can't find the ISNULL function. I'm using Office 2003 Small Business Edition. I've used this function before in a different version of office but I can't seem to find it with this version. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions | |||
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions | |||
SUMIF(AND) FUNCTION | Excel Worksheet Functions |