| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to display text depending upon date entered in a cell
I thought this would be simple, but it has defeated me.
Assume that cells in column A are used to capture a future due date. In column B, I need a formula that will display "Not Due Yet" if the date in column A hasn't been reached, or "To Do" if we are at or past the date. I was able to write a formula to do this successfully, but for some reason it defaults to "To Do" on the rows where there is no entry in column A. I tried using the ISBLANK function, but the problem is that the cell has a formula in it that brings the text over from another worksheet, so I suppose it isn't truly a blank cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to display text depending upon date entered in a cell
Try TRIM, eg: =IF(TRIM(A1)="","",<yourexpression)
-- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Rod from B.C. Government" wrote: I thought this would be simple, but it has defeated me. Assume that cells in column A are used to capture a future due date. In column B, I need a formula that will display "Not Due Yet" if the date in column A hasn't been reached, or "To Do" if we are at or past the date. I was able to write a formula to do this successfully, but for some reason it defaults to "To Do" on the rows where there is no entry in column A. I tried using the ISBLANK function, but the problem is that the cell has a formula in it that brings the text over from another worksheet, so I suppose it isn't truly a blank cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to display text depending upon date entered in a cell
Always helps us if you post the actual formula but maybe..........?
=IF(A1="","",yourformula) Gord Dibben MS Excel MVP On Mon, 25 May 2009 13:48:01 -0700, Rod from B.C. Government wrote: I thought this would be simple, but it has defeated me. Assume that cells in column A are used to capture a future due date. In column B, I need a formula that will display "Not Due Yet" if the date in column A hasn't been reached, or "To Do" if we are at or past the date. I was able to write a formula to do this successfully, but for some reason it defaults to "To Do" on the rows where there is no entry in column A. I tried using the ISBLANK function, but the problem is that the cell has a formula in it that brings the text over from another worksheet, so I suppose it isn't truly a blank cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| Display Row Borders When Text entered in Any Cell | Excel Discussion (Misc queries) | |||
| Date changes to formula when entered in a cell | Excel Worksheet Functions | |||
| display text depending on coice from drop down list | Excel Discussion (Misc queries) | |||
| Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
Linear Mode
