Hello,

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

function for "n+1"? sorry, can you please elaborate a little bit?


"Eric" wrote:

Hello,

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

Function Inc(rngAdd as range, rngMax as Range)
If rngAdd.Value = maxRange.Value Then
Inc = maxRange.Value
Else
Inc = rngAdd.Value + 1
End If
End Function

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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?

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?

Hi Eric,

Is your n value the n in a statistical analysis range.
If that is the case you could use =COUNT(A:A)+1
or if you need to limit the length of the range
use =COUNT(A1:A50)+1 or whatever.

HTH
Martin