MattioMatt
Registered User.
- Local time
- Today, 15:46
- Joined
- Apr 25, 2017
- Messages
- 99
Hello,
I currently have the following IF statement
This gives me...
1. If cell is less than 12 months old = Green
2. If cell date is more than 12 months old = Red
I would like to amend it to:
1. If cell is less than 12 months old = Green
2. If cell is more than 12 months old but less than 18 months old = Amber
3. If cell is more than 18 months old = Red
I'm struggling on the point 2 where the date could be in between ranges. Is there anyway to do this in an if statement?
I currently have the following IF statement
Code:
=IFS(AF12>=TODAY()-365,"Green",AF12<TODAY()-365,"Red")
This gives me...
1. If cell is less than 12 months old = Green
2. If cell date is more than 12 months old = Red
I would like to amend it to:
1. If cell is less than 12 months old = Green
2. If cell is more than 12 months old but less than 18 months old = Amber
3. If cell is more than 18 months old = Red
I'm struggling on the point 2 where the date could be in between ranges. Is there anyway to do this in an if statement?