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)
|