Capping number of attendees that increase monthly

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

 

[Mike H]

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

 

[Barb Reinhardt]

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

 

[E]

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.

 

[E]

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

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]

That did the trick! Thanks much!

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

 

[franciz]

Hi Mike

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


Thanks,

 

[Mike H]

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

 

[Mike H]

no it doesnt!!


FLOOR(2.5, 1) returns 2

Mike

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