LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 331
Default Cannot 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage total may not exceed 100 The Fool on the Hill Excel Discussion (Misc queries) 5 September 6th 07 03:26 PM
Exceed Row Limit Freshman Excel Worksheet Functions 6 August 9th 07 05:10 PM
Exceed Row Limit Freshman Excel Worksheet Functions 0 August 9th 07 05:22 AM
Matching a value, which does not exceed Min or Max. Assad Excel Worksheet Functions 3 July 15th 07 05:08 PM
Exceed Scale MarkN Charts and Charting in Excel 5 November 12th 06 09:29 PM


All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"