is null is not an XL function...

You could also just use

=IF(B3="","",B3)



In article ,
"scott" wrote:

why does iif combined with is null fail?