Formula

MatthewRush

New Member
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

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

MatthewRush

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

Many thanks

SQUIDD

Well-known Member
try this

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

Dave

SQUIDD

Well-known Member
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

New Member
Thank you so much!! Works brilliant!!

great

Replies
0
Views
186
Replies
3
Views
161
Replies
4
Views
152
Replies
16
Views
1K
Replies
0
Views
200

1,191,687
Messages
5,988,019
Members
440,125
Latest member
vincentchu2369

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back