Without resorting to VBA Macros why not put a nested IF statement around
your formula.
Something Like ---
=IF($A2 < 99, your formula with + 2000, your formula with + 1900)
Your formula is then a function of the year, adding 2000 for less than an
implied 1999 and 1900 for an implied greater than 1998. I say implied
because you must decide when the century rolls over which I guess depends on
your historical view and data requirements. You could choose the test as
=IF($A2<60.......) which would give you a range of 1960 to 2059 which I
guess would cover most situations?
Cheers
Nigel
"timspin " wrote in message
...
Hi all,
Please help me,
as you can see I am calculating cost depreciation over four years,
starting from the year after the year number in A2. My problem is
dealing with 99 or 98 is fine, but as soon as I get to 00, 01 etc
things go pear shaped. I would like to somehow use nested if and
statement to determine what type of year it is (98 etc or 01 etc) -
and then to calculate the depriciation as determined by my formula.
Sadly, changing the date format isnt an option, please any advice?
All the best
Tim Gee
Attachment filename: excelpict.bmp
Download attachment:
http://www.excelforum.com/attachment.php?postid=611695
---
Message posted from http://www.ExcelForum.com/