View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Posts: n/a
Default How to replace null values with zero?

I know how to do this in an Access query... I just don't want to take my list
of data over there and bring it back to Excel. Is there a function that can
do something like an IF statement:

=IF(IsNull(A1), A1, 0)