Excel Formula
Solved/Closed
Related:
- Excel Formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 21, 2010 at 02:15 PM
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))))
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))))
Jul 22, 2010 at 08:11 AM
https://authentification.site/files/23476157/year.xls
Jul 22, 2010 at 09:42 AM
Jul 22, 2010 at 11:21 AM
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.
Jul 22, 2010 at 01:56 PM
https://www.mrexcel.com/board/threads/animating-text-in-excel.9270/
Jul 23, 2010 at 09:53 AM
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