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...
Replacement of equipment occurs when it reaches the end of its service life, not after one year from such end; otherwise, no such equipment would be available for use within that one year period.
Premised on the foregoing, the formula in K3, copied to the right, is:
=((YEAR($C3)+$I3)=K$2)*($D3*$E3)
Premised on the foregoing, the formula in K3, copied to the right, is:
=((YEAR($C3)+$I3)=K$2)*($D3*$E3)
