Thread: Cannot Exceed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Greg is offline
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.