View Single Post
  #3  
Old June 17th, 2009, 06:03 PM posted to microsoft.public.excel.worksheet.functions
Max
external usenet poster
 
Posts: 8,574
Default formula for 'If a cell is empty then insert numeric Zero'

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