IF & AND formula

J

jeff

Hi,

work with this: it assumes your dates are in A1:BC1
and your values are in A2:BC2. Manipulate as needed.and
drag across...

=IF(MONTH(A1)<12,A2,A2*1.1)

jeff
-----Original Message-----
newbie question..

I have 5 cells (A2:E2) which have different percentages

the headers of these cells (A1:E1) have year-end date
Click to expand...
eg. 12/31/2004, 12/31/2005, etc
then i have another row (A3:BC3) with month-end dates
Click to expand...
starting with 6/30/2004 through 12/31/2008
beneath those i have a june start value of 100 in cell A4..

is there a formula that will apply the growth rates from
Click to expand...
A2:E2 to the starting value starting in december 2004
and "carry" that value across until we reach another
december, and then apply the corresponding growth rate to
it?
 
Top