View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

Try this changing A1 to B3:

=OR(ISBLANK(A1),A1="")

=IF(OR(ISBLANK(A1),A1=""),"",A1)


"scott" wrote in message
...
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)