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:

In cell A3	=A1+1
In cell A4	=A1+2
In cell A5	=IF(A2=4,(A1+3),"")
In cell A6	=IF(A2=4,(A1+4),"")

<tbody>
</tbody>

 

[Malcolm torishi]

Thank you

 

[philwojo]

No problem, glad to help.