| 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. |
|
#2
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") Maybe something like this would help: =IF(B4="","",IF((TODAY()-B4365), "EXPIRED", "CURRENT")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula current/expired/blank
Hi Warren,
Try the following. =IF(B4="","",IF((TODAY()-B4365), "EXPIRED", "CURRENT")) -- Regards, OssieMac "Warren Jo" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula current/expired/blank
On 2/28/2010 6:14 PM, Warren Jo wrote:
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. Hi. Another option: =IF(ISBLANK(B4),"",IF(EDATE(B4,12) TODAY(),"Expired","Current")) = = = = = = = HTH :) Dana DeLouis |
| Reply |
| 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 | |||
Linear Mode
