The function is =N1+1, where cell N1 contains your value N.

If you want it to stop when it reaches another cell's value, you can use
=MIN(N1+1,A1) where A1 is the other cell.
--
David Biddulph

"Eric" wrote in message
...
Hello,

Is there a function for n+1? also how do I tell it to stop when the cell
equals another cells value?