User Profile
InOverMyHead
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: I need a cell to use a simple formula if date conditions are met
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.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 k3 to z3, I want o3 (in the case of the end of service date for row 3) to populate with a purchase price d3*e3 quantity owned to tell us we need to plan to budget in 2023 for $31455. I got conditional formatting to work for applying Red, yellow, green for due dates in the J column. **I am aware of how that particular math will be flawed based on the spreadsheet given to me since it was $31455 for 3 of them on the sheet, but I am dealing with what was handed to me and I will fix that math later, so please ignore that part if you see it in the picture.
