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