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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Calculate the median value before a specified list 0
Calculations with possible null value fields 1
Multiple IIf with Is Null 2
Matching literal text "???" in Word 2010 field code IF statement 2
New computer, how do i move outlook 365 ENTIRELY? 0
Convert zero-length string or blank cell to null 3
Using Drop Down list to an If Statement to another Drop Down list 3

Top