Fourmula help

[Guest]

I need to create a formula here is the situation:

Have to create a depreciation worksheet for our assets. Items are dep over a
7 year period, cells are created for 2002-2003 2003-2004 blah blah.

I need the 2002 cell to have a forumal that will reference the date cell and
decide if the date is between 2002 and 2008 then populate the cell with a
value it pulls from a diffrent cell (this cell calculates the item cost /7)
this as to happen through all the years.

How would you write this formula?

Thanks for the help in advance.

Steve Good
Colstrip Public Schools

 

[Guest]

Hi Steve,

I would do this:
A B C
1 01/04/2002 31/03/2008
2
3 01/09/2006
4
5 £150.00 (this is the depreciation amount for the month)


If cell A3 is today, then:

=if(and($A$3>$A$1,$A$3<$B$1),$A$5,0)

Hope this helps

Amanda