Am I able to reference the 150 from another cell? For instance
=MIN(D3,CEILING(D2*1.05,1)), where D3 is the maximum?

"Sandy Mann" wrote:

=MIN(150,CEILING(D2*1.05,1))

--
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
...
Thank you Sandy. One more question, how do I then include a CEILING
function
to round up within this equation? I cannot have .25 of a unit. Thanks
again!

"Sandy Mann" wrote:

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.