Add a number to a cell

[Malcolm torishi]

In cell A1 is 100, in cell A2 is 2. So what I would like to do in cell A3 would be to add 1 to A1 cell 100 = 101, then in cell A4 add 2 to A1 cell 100 = 102. But if cell A2 was 4. I would like to continue to add 1 a further 2 times so cell A5 would = 103 and cell A6 would = 104.
Thank you

 

[philwojo]

Try this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]In cell A3[/TD]
[TD]=A1+1[/TD]
[/TR]
[TR]
[TD]In cell A4[/TD]
[TD]=A1+2[/TD]
[/TR]
[TR]
[TD]In cell A5[/TD]
[TD]=IF(A2=4,(A1+3),"")[/TD]
[/TR]
[TR]
[TD]In cell A6[/TD]
[TD]=IF(A2=4,(A1+4),"")[/TD]
[/TR]
</tbody>[/TABLE]

 

[Malcolm torishi]

Thank you

 

[philwojo]

No problem, glad to help.