Excel Formula

Solved/Closed
Report
-
 Neo -
Hello,

I need a formula to accomplish the following.

5 + years => 15
10 + years => 20
15 + years => 25
20 + years => 30

eg. say I was hired on 1996, I want a formula that would give me the result of 20, because 1996 to now is 14 years. etc...



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
It seems to be a half complete question.

you can have nested if to do it


=IF(year(today()) - Year(a1) < 5, 0, IF(year(today()) - Year(a1) < 10, 15, IF(year(today()) - Year(a1) < 15, 20,IF(year(today()) - Year(a1) < 20, 25,30))))
https://authentification.site/files/23490741/SAMPLE.xls

Hi Rizvisa, You have helped me before with this, I'm hoping you can do the same. Please view the attachment for what I want done. Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I dont think this is related to scrolling text. Could you open a new thread for that. For past some time I have been very very busy, so it may take some time. It will be better for you too if you open a new thread, as some one else may take a look at it and resolve it for you.
Posts
47367
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,264
Rizvisa

Sorry for interrupting your thread but I could not help it! I am always amazed, estonished. Nice to see you at work helping. It is almost as if you were Excel's creator.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Mighty mighty kind of you Ambucias
I will open a new thread. Could not agree more witj Ambucias, you're REALLY good at this, and thanks again for all your help.