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
760
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
760
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
48725
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 23, 2020
15,388
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
760
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.