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.
|