Capping number of attendees that increase monthly
Hi Mike
would you elaborate on this formula, what does Ceiling does? it the first
time I come across this function.
Thanks,
"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!
|