View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E[_2_] E[_2_] is offline
external usenet poster
 
Posts: 40
Default Capping number of attendees that increase monthly

Thanks Mike! I will give this a try...

"Mike H" wrote:

Probably not enough information but with your starting number in a1, put this
in A2 and drag down.

=MIN(60,CEILING(A1*1.03,1))

Mike

"E" wrote:

Hi,
I am trying to show an increase of 3% monthly in program attendees, but want
to cap the number at 60 and create a waiting list. How do I write that
condition into the formula so it stops increasing the attendees at 60?

Thanks!