 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2007Cannot Exceed
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. With 100 in D2, in D3 and below enter: =MIN(150,D2*1.05)  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >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. [quoted text clipped - 3 lines] > 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. 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! > With 100 in D2, in D3 and below enter: > [quoted text clipped - 7 lines] > > 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. =MIN(150,CEILING(D2*1.05,1)) SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Thank you Sandy. One more question, how do I then include a CEILING > function [quoted text clipped - 15 lines] >> > growth >> > once it hits 150 units? Any help would be appreciated. Am I able to reference the 150 from another cell? For instance =MIN(D3,CEILING(D2*1.05,1)), where D3 is the maximum? > =MIN(150,CEILING(D2*1.05,1)) > [quoted text clipped - 17 lines] > >> > growth > >> > once it hits 150 units? Any help would be appreciated. Hi Greg, Just try! SignatureKind regards, Niek Otten Microsoft MVP - Excel | Am I able to reference the 150 from another cell? For instance | =MIN(D3,CEILING(D2*1.05,1)), where D3 is the maximum? [quoted text clipped - 20 lines] | > >> > growth | > >> > once it hits 150 units? Any help would be appreciated. I did, not work. So then no... > Hi Greg, > [quoted text clipped - 24 lines] > | > >> > growth > | > >> > once it hits 150 units? Any help would be appreciated. What is "not work"? Either of these return the same value or a ceiling of 150 =MIN(150,CEILING(D2*1.05,1)) =MIN(D3,CEILING(D2*1.05,1)) when D3 contains 150 Isn't that what you wanted? Gord Dibben MS Excel MVP >I did, not work. So then no... > [quoted text clipped - 26 lines] >> | > >> > growth >> | > >> > once it hits 150 units? Any help would be appreciated. Yes but surely you would not want to use D3? Are you not about to overwrite D3 and that would give you a circular reference. Pick another cell and make the reference to it Absolute. For example, if the cell with the Maximum value that you want was E2 then make the formula in D3: =MIN($E$2,CEILING(D2*1.05,1)) and copy down on the fill handle. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Am I able to reference the 150 from another cell? For instance > =MIN(D3,CEILING(D2*1.05,1)), where D3 is the maximum? [quoted text clipped - 22 lines] >> >> > growth >> >> > once it hits 150 units? Any help would be appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.