Hi Greg,

Just try!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Greg" wrote in message ...
| 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.
|
|
|
|
|
|
|
|