N + 1

E

Eric

Hello,

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

Bob Phillips

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)
 
D

David Biddulph

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.
 
M

MartinW

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
 
Top