Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KitKat
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
KitKat
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
George Nicholson
 
Posts: n/a
Default

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   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
Find a Function to use accross different worksheets R. Hale Excel Worksheet Functions 3 November 25th 04 07:07 AM
Find function Jahunga Excel Worksheet Functions 2 November 22nd 04 03:38 PM
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA hsg Excel Worksheet Functions 2 November 18th 04 07:24 AM
SUMIF(AND) FUNCTION Saariko Excel Worksheet Functions 9 October 28th 04 11:52 AM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"