| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula current/expired/blank
I'm using this formula to return a 'current' or 'expired' value depending on
the date in column B (expiry after one year). Because I want to autofill rows that don't yet have data, I require some extra criteria so that no value is returned if B is still blank. Comprehend?? =IF((TODAY()-B4365), "EXPIRED", "CURRENT") It may be a bit clumsy, so comments on this base formula would also be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto insert a blank row above the current row based on a cell val. | Excel Discussion (Misc queries) | |||
| find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") | Excel Worksheet Functions | |||
| How can I check a cell for current date and insert it if blank? | New Users to Excel | |||
| Page expired? | New Users to Excel | |||
| Expired Date Formula | Excel Worksheet Functions | |||
Threaded Mode
