Forum Discussion
I need a cell to use a simple formula if date conditions are met
I am trying to plan for large expenses as equipment reaches it's lifespan. I want to take a dynamic 15 year span, and if a: date of purchase c3 plus expected lifespan i3 is more than a given year k...
I understand you want a formula in cells K3 to Z3 that calculates a number if the year in row 2 is greater than the service date year plus lifespan. I don't see any number in column I in your screenshot, but I think the following formula should do what you describe. Put the formula into K3 and copy to the right.
=IF(YEAR($C3)+$I3+1=K$2,$D3*$E3,0)