# Excel Formula

Solved/Closed
Related:

- Excel Formula
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets

## 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