Excel Formula

Solved/Closed
Neo - Jul 21, 2010 at 09:04 AM
 Neo - Jul 23, 2010 at 12:50 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 21, 2010 at 02:15 PM
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))))
0
I tried the formula, but something is not working properly, the only answer i get is 30, no matter what year i put in A1. Attached is an example.

https://authentification.site/files/23476157/year.xls
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 22, 2010 at 09:42 AM
Year() is a function that take a DATE and extract year from it. You already have an year.
0
Thanks...

I asked a question a few days ago but I got no response. Do you know if there is a way to get scrolling text / marquee effect in excel or word ? preferably in excel.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 22, 2010 at 01:56 PM
0
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
0