How to replace null values with zero?

E

Eric

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