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?
=IF(B3<>15,YEAR(TODAY())+(15-B3),2015)
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.=IF(B3<>15,YEAR(TODAY())+(B3-15),2015)
=B3+2000
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks