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.

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.

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.

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.

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.