END GAME: Looking for a cell to say the year in which something can come eligible.
In the yellow cells, I would like there to be a formula to say: if green cell is not 15, then take the current year +the difference between green and 15. Please help. Thanks!
Does this do what you are looking for?
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
You da man
If you do the difference the other way (B3-15), you just get the year of the number you are looking at.
Which means this formula would be much easier.Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks