Formula Help

[Sasikiran]

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.

 

[Mike H]

Hi,

Try this and drag down as required

=INT(B8/2)

Mike

 

[Sasikiran]

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.

 

[Steve]

Try :

=ROUND((INT(B8/2),0)

If this helps - click Yes

 

[Steve]

Sorry - I meant this:

=ROUND(B8/2,0)

INT will round down.