With 100 in D2, in D3 and below enter:

=MIN(150,D2*1.05)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Greg" wrote in message
...
I am working on a formula based on 5% growth per month. I started out with
100 units in January and in February that number will be 105, and so on.
I
have a maximum number of 150 units I cannot exceed for a formula. Is
there
anyway to set this up as a growth rate per month and then stop the growth
once it hits 150 units? Any help would be appreciated.