June 17th, 2009, 06:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|
formula for 'If a cell is empty then insert numeric Zero'
In what way would that give a different result from =A2 ?
--
David Biddulph
"Max" wrote in message
...
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
---
|