Inventory demand (rounding)

[New User]

Summary:

YR 1 .3 Because demand for the 1st year is less
than .5. I want to insert a value of 0.

YR 2 .3 Because the cummulative value for years 1 & 2
is greater than .5 I want to insert a value of 1.
=====================================================

YR 3 .3 Because demands for year 3 is less than .5
I want to insert a value of 0.

YR 4 .3 Because the cummulative value for years 3 & 4
is greater than .5 I want to insert a value of 1.
=======================================================

YR 5 .3 Because demand for the last year is less
than .5. I want to insert a value of 0.

========================================================

The actual demands look like:

YR1 YR2 YR3 YR4 YR5

Shirt .3 .3 .3 .3 .3

Using the rounding method noted in the above summary. I
would like find a forumla that would do the following.

YR1 YR2 YR3 YR4 YR5
Shirt 0 1 0 1 0

Thanks very much for the help!

 

[Trevor Shuttleworth]

=ROUND(A2,0) in A3 (Year 1)

then:

=ROUND(SUM(A2:B2),0) in B3 (Year 1+2)
=ROUND(C2,0) in C3 (Year 3)
=ROUND(SUM(C22),0) in D3 (Year 3+4)
=ROUND(E2,0) in E3 (Year 5)

Regards

Trevor

 

[New User]

Trevor,

thanks for the information. You almost have the right
idea! The problem being is that I have several thousand
rows on the spreadsheet and its not practical to insert
the formula in every other row.

I need a formula that will do what your formula does but
for every row in a specific column (yr1 being column 1,
etc).

 

[Trevor Shuttleworth]

OK, so put the formulae on the same row somewhere to the right of your data
and drag down or use autofill

Regards

Trevor