Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
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" 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
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. "Barb Reinhardt" wrote: 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" 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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
Thanks Mike! I will give this a try...
"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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
That did the trick! Thanks much!
"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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
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 "franciz" wrote: 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! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capping number of attendees that increase monthly
no it doesnt!!
FLOOR(2.5, 1) returns 2 Mike "Mike H" wrote: 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 "franciz" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
auto increase number if number is double or more | Excel Worksheet Functions | |||
Capping Letters in EXCEL | Excel Discussion (Misc queries) | |||
Capping results | Excel Discussion (Misc queries) | |||
List of attendees | Excel Discussion (Misc queries) |