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 i
dealing with 99 or 98 is fine, but as soon as I get to 00, 01 et
things go pear shaped. I would like to somehow use nested if an
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 Ge

Attachment filename: excelpict.bmp
Download attachment: http://www.excelforum.com/attachment.php?postid=61169
--
Message posted from http://www.ExcelForum.com

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/