I need a formula that will determine if a cell is blank and if it is, will put a 0 (zero) in that cell but if it's not blank, will leave the value as it is in that cell.
Written out it's like this:
If cell n2 is blank, enter a zero but it there is a number there, leave that number there.



Hope that explains it. I thought this would be a simple if statement but I can't get it work.

Mike

=if(isblank(n2),0,n2)

Of course, this will have to be in another cell. If you absolutely need it to be in n2, then I'm pretty sure that will require coding.

If you want to put 0s into blank cells:
• insert a 0 in to any cell
• copy the 0 to the clipboard
• select the destination range (even spanning cells that aren't empty, but not including cells that have formulae)
• use Paste Special>Values>Add

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

type a zero into a cell, copy it to your clip board, highlight the cells you want to replace blanks with zeros in, hit F5, click the radio button next to "blanks"; click OK, then hit CTRL+V

F5 just displays the 'Goto' box, with no radio buttons or 'blanks'. And what though have you given to the effects this has on formulae in the destination range?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Macropod, you're correct, I did skip a step in my explanation. it should have said:
type a zero into a cell, copy it to your clip board, highlight the cells you want to replace blanks with zeros in, hit F5, Click the "Special" button, then click the radio button next to "blanks"; click OK, then hit CTRL+V

As for formulae in the destination range, if the cell is blank, it wouldn't necessarily have a formula in it. Perhaps my solution isn't the appropriate solution for the OP's scenario in that regard. It was intended to be a helpful suggestion.