Give blank in cell
=IF(A1="","",A1+1)
--
David Biddulph
"bbc1" wrote in message
...
I have 10 cells in column A
A1
A2
A3
A4
A5
etc
What I require is if cell A1 is blank then blank in all cells, if A1 is
one
then add one to each cell
ie if A1 =1 A2 =2
|