Sequence Number in a diferrent cell

Hi

I need a formula code that will sequence my number from A1.
Let say I have a number 8 AND i will place the code to different cell that will sequence number to 9

thanks.

I think this one will work.

=A1+1

but I need to have it to appear blank in a cell when where is nothing in A1.
I believed I need an =IF.....

Thanks.

Hi,

So, everytime in place this code I have to change A1 to another cell?
Let say my number in A1 is 8 and I placed the code in C1 so the next one will =IF(N(C1),C11+1,"")?

thanks.

OK. Here is the sample one. Thank you.

Hi Jeffrey
I think I got it.
The code you provided is good enough.

Thank you for your help.