How to replace null values with zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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