Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Dear,
I need your help in counting the number of people required for each slot based on the number of transactions. In column B i have a number. In column C i need to insert a formula which counts the number of people required for every 2 transactions. Say in B9 the number is 4, by formula the count in C9 should be 2. For every 2 rise in number in column B, the required number in column C increases by 1 number. Please advise. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Hi,
Try this and drag down as required =INT(B8/2) Mike "Sasikiran" wrote: Dear, I need your help in counting the number of people required for each slot based on the number of transactions. In column B i have a number. In column C i need to insert a formula which counts the number of people required for every 2 transactions. Say in B9 the number is 4, by formula the count in C9 should be 2. For every 2 rise in number in column B, the required number in column C increases by 1 number. Please advise. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Dear Mike,
Thank you but a small addition to the requirement. If the value is 1 the corresponding number requires is showing as 0. Can we tweak the formula in such a way that the count remains 1 in column C if the value in column B is either 1 or 2 and there after rise in every 2 the number required in column C should increase by 1. Thank you. "Mike H" wrote: Hi, Try this and drag down as required =INT(B8/2) Mike "Sasikiran" wrote: Dear, I need your help in counting the number of people required for each slot based on the number of transactions. In column B i have a number. In column C i need to insert a formula which counts the number of people required for every 2 transactions. Say in B9 the number is 4, by formula the count in C9 should be 2. For every 2 rise in number in column B, the required number in column C increases by 1 number. Please advise. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Try :
=ROUND((INT(B8/2),0) If this helps - click Yes "Sasikiran" wrote: Dear Mike, Thank you but a small addition to the requirement. If the value is 1 the corresponding number requires is showing as 0. Can we tweak the formula in such a way that the count remains 1 in column C if the value in column B is either 1 or 2 and there after rise in every 2 the number required in column C should increase by 1. Thank you. "Mike H" wrote: Hi, Try this and drag down as required =INT(B8/2) Mike "Sasikiran" wrote: Dear, I need your help in counting the number of people required for each slot based on the number of transactions. In column B i have a number. In column C i need to insert a formula which counts the number of people required for every 2 transactions. Say in B9 the number is 4, by formula the count in C9 should be 2. For every 2 rise in number in column B, the required number in column C increases by 1 number. Please advise. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Sorry - I meant this: =ROUND(B8/2,0) INT will round down. If this helps - click Yes "Sasikiran" wrote: Dear Mike, Thank you but a small addition to the requirement. If the value is 1 the corresponding number requires is showing as 0. Can we tweak the formula in such a way that the count remains 1 in column C if the value in column B is either 1 or 2 and there after rise in every 2 the number required in column C should increase by 1. Thank you. "Mike H" wrote: Hi, Try this and drag down as required =INT(B8/2) Mike "Sasikiran" wrote: Dear, I need your help in counting the number of people required for each slot based on the number of transactions. In column B i have a number. In column C i need to insert a formula which counts the number of people required for every 2 transactions. Say in B9 the number is 4, by formula the count in C9 should be 2. For every 2 rise in number in column B, the required number in column C increases by 1 number. Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|