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

  • Thread starter Thread starter P Ryan Nutribio
  • Start date Start date
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
---
 
Back
Top