View Single Post
  #1   Report Post  
scott
 
Posts: n/a
Default IIF IS NULL Problem

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)