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?