MatthewRush
New Member
- Joined
- Nov 24, 2016
- Messages
- 4
Hi,
I have a formula for Certificates Expired & Expiring soon...Can i add into the formula,so it says "In date".
I have Red for expired
Yellow for Expiring soon
I wanted Green for In date..
This is my formula - =IF(F5<0,"Expired",IF(F5<30,"Expiring soon",""))
Any help greatly appreciated
I have a formula for Certificates Expired & Expiring soon...Can i add into the formula,so it says "In date".
I have Red for expired
Yellow for Expiring soon
I wanted Green for In date..
This is my formula - =IF(F5<0,"Expired",IF(F5<30,"Expiring soon",""))
Any help greatly appreciated