formula for 'If a cell is empty then insert numeric Zero'

[Max]

Perhaps you meant to do something like this
In B2, copied down: =IF(A2="",0,A2)
which inserts zeros where col A is empty
otherwise replicate col A's values

Roger? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---

 

[David Biddulph]

In what way would that give a different result from =A2 ?

 

[Max]

In what way would that give a different result from =A2 ?

It gives the OP an opportunity to see how to frame up a typical IF
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---