Previous Topic Next Topic

Excel Formula

Solved/Closed
Neo - 21 Jul 2010 à 09:04
 Neo - 23 Jul 2010 à 12:50
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
21 Jul 2010 à 14:15
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))))
Neo
22 Jul 2010 à 08:11
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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 Jul 2010 à 09:42
Year() is a function that take a DATE and extract year from it. You already have an year.
Neo
22 Jul 2010 à 11:21
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.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 Jul 2010 à 13:56
See this
https://www.mrexcel.com/board/threads/animating-text-in-excel.9270/
Neo
23 Jul 2010 à 09:53
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses