Capping number of attendees that increase monthly

  • Thread starter Thread starter E
  • Start date Start date
E

E

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!
 
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
 
Your quesiton is kinda cryptic. What exactly do you have and what are you
trying to do. We'll help, but we aren't mind readers nor can we see the
data that you see.

Barb Reinhardt
 
Sorry--I have a tendency to give too much info, so I was trying to edit.

I am working on a budget for a care facility. State regulations cap the
number of attendees allowed at 60, so as I project an increase in attendees
on a monthly basis at 3% growth, I need to be sure everything caps at 60
attendees. I am starting with 40 attendees, but will go over the cap by the
end of a 12 month period at my 3% increase, so I need to build the formula in
a way that it won't allow the growth past 60.
 
Thanks Mike! I will give this a try...

Mike H said:
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
Click to expand...
 
That did the trick! Thanks much!

Mike H said:
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
Click to expand...
 
Hi Mike

would you elaborate on this formula, what does Ceiling does? it the first
time I come across this function.


Thanks,
 
Hi,

Ceiling is one of the Excel rounding functions which rounds up to a multiple
so

=CEILING(2.5, 1)

Takes the number 2.5 and rounds to a multiple of 1 so returns 3.

The opposite function is (Unsurprisingly) Floor

=FLOOR(2.5, 1) returns 1.

you have to be careful with these because they actually change the value of
a number compared to a format which only changes the way we see the number.

All of these are documented in Help

Mike
 
no it doesnt!!


FLOOR(2.5, 1) returns 2

Mike
Mike H said:
Hi,

Ceiling is one of the Excel rounding functions which rounds up to a multiple
so

=CEILING(2.5, 1)

Takes the number 2.5 and rounds to a multiple of 1 so returns 3.

The opposite function is (Unsurprisingly) Floor

=FLOOR(2.5, 1) returns 1.

you have to be careful with these because they actually change the value of
a number compared to a format which only changes the way we see the number.

All of these are documented in Help

Mike
Click to expand...
 
Back
Top