View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Capping number of attendees that increase monthly

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!