If you check help, you'll not find (1) any functions that consist of two words
separated by a space, or (2) any function involving NULL. Maybe you are
thinking of VBA.

The worksheet function is ISBLANK (note one word, not 2).

On Mon, 3 Jan 2005 11:06:13 -0600, "scott" wrote:

I'm trying to test a cell to return a blank "" or the number. If cell B3
contains nothing, how can i return a blank?

i'm using below formula, but it gives me an error.

=IF(IS NULL(B3),"",B3)