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...
Twifoo SergeiBaklan IngeborgHawighorst
Thank you all for your input. After trial of both, I found the one that Twifoo provided to work. Ineborg, yours worked also, but inserted the budget into the following year.
You are all wonderful. Thank you for your assistance.
InOverMyHead the formula I suggested puts the amount in the following year because of the +1 in the formula. Remove it if you want. It's how I understood the requirement.
Twifoo's formula is clever and shorter, but unless you really understand how it works, you may find it hard to maintain. An IF statement is a lot clearer than a multiplication with a comparison. I prefer to keep it simple and easier to understand.