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