Hello,

I was wondering if I could please have some help with the following formula. I think I have the logic correct but just can't seem to get the answer I expect. I am trying to do a depreciation schedule for our computer assets and find out all the computers that need to be replaced this year (before 31/12/2010) that havent been replaced or stolen.

The columns involved in this formula are-
Column D - Purchase Value
Column J - Replacement Date
Column M - Asset Status
Column L - Replacement Value this year - this is the column where the answer should go

I need to check if a computer was (1) bought before 31/12/2010 AND (2) if the computer has been lost or stolen. This is represented by an "R" or "S" in column M.

Here is the formula-
=IF(AND(J2<="31/12/2011",(OR(M2="R",M2="S"))),D2,"0")

Is this logic correct?

Thank you,

Jaime