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!
|