ExcelBanter - Give blank in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Give blank in cell (https://www.excelbanter.com/excel-discussion-misc-queries/251807-give-blank-cell.html)

bbc1

Give blank in cell

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

David Biddulph[_2_]

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

Minty Fresh

Give blank in cell

Try this
=IF(ISBLANK(A$1),"",ROW()+A$1-1)

"bbc1" wrote:

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

bbc1

Give blank in cell

Thanks just what I was looking

"Minty Fresh" wrote:

Try this
=IF(ISBLANK(A$1),"",ROW()+A$1-1)

"bbc1" wrote:

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

All times are GMT +1. The time now is 12:47 AM.