Formula

[MatthewRush]

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

 

[MatthewRush]

I forgot to mention, If the days are greater than 30 that would be "In date"

Many thanks

 

[SQUIDD]

try this

=IF(F5<0,"Expired",IF(F5<30,"Expiring soon",IF(F5>29,"In Date",""))

Dave

 

[SQUIDD]

or this

=IF(F5<0,"Expired",IF(F5<=30,"Expiring soon",IF(F5>30,"In Date","")))

this will be expiring soon if 30 or under and in date if more than 30

Dave

 

[MatthewRush]

Thank you so much!! Works brilliant!!

 

[SQUIDD]

great

your welcome