Allocation of values to months

G

Graham

Just cannot seem to get a simple way to do this. I have three values in each
row eg
A2=3, B2=4, C2=300. I then have 12 columns which represent the months of
the year headed 1,2 3 etc.
A2 represents the month, C2 with 300 represents the value to allocate to
that month, and B2 gives the number of months that this value will be
allocated to , starting at month 3. This should finish up with 300 in
columns 3,4,5 and 6. If the columns started in column D for example this
would mean that F2, G2, H2 and I2 were each 300. This would carry on for
about 150 rows with different values in A3, B3, C3 etc. I hope this is
understandable!
I am sure there must be a procedure or an easier way to do this rather than
multiple If formulas. I would value any guidance.

Kind Regards
Graham Haughs
Turriff, Scotland
 
B

Bob Phillips

Graham,

In D1 enter
=IF(D$1>=$A2,IF(D$1<$A2+$B2,$C2,""),"")
and copy across

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

jeff

Hi, Graham,

Try this in your sample D2 and drag (copy) across
to your December cell (O2); then drag (copy) down.

=IF(AND(D$1>=$A2,D$1<=$B2+$A2-1),$C2,"")

jeff
 
G

Graham

Many thanks Bob. I was going round in ever decreasing circles for a long
time with no sign of a conclusion and I most appreciate your quick response
and perfect solution.

Graham
 
B

Bob Phillips

Jeff,

<=$B2+$A2-1

is a bit superfluous, just use

<$B2+$A2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top