|
|
#7
08-09-2015, 08:08 AM
|
|||
|
|||
B2=$H$1,"Due today"
B2<$H$1,E2<>0, E2<>0 is "Missing" when there a date in E2 if it is greater the $H$1,"Current", if less than "Expired" B2>=$H$1,E2<$H$1, I need to think on this. D2="" D will always have a yes or no, system report.(I should stated before) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 multiple conditions, and blank cells with the countifs function
|
jaden0605 | Excel | 1 | 03-30-2014 01:50 AM |
| 6 conditions formula | paconovellino | Excel | 2 | 03-05-2012 06:45 AM |
|
3 Conditions
|
Laurie B. | Excel | 4 | 08-15-2011 10:27 PM |
|
Count with multiple conditions
|
bundy5150 | Excel | 4 | 02-22-2011 10:00 AM |
|
Using Conditions to Add Values
|
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |
Windows 8 
Office 2007
Threaded Mode