Allocation of values to months

  • Thread starter Thread starter Graham
  • Start date Start date
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
 
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)
 
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
 
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
 
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)
 
Back
Top