Scott

Maybe =IF(ISBLANK(B3),"",B3)

Note: if B3 is blank due to its having an IF formula that returns "", it will
pass the ISBLANK test, so ISBLANK is not really NULL.


Gord Dibben Excel MVP

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)