Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have this formula in cell I: =IF(H228K228,"Past TAT","")
I Have this formula in cell H: =IF(OR(Y228<"",W228=""),"",TODAY()-W228) Here is the problem: Even though cell H is blank because no date has yet been added to cell W, cell I keeps showing "Past TAT." It seems that the cell I sees something in cell H, but it is blank other than the formula that is not seen. When I hit the delete key while in cell H, the Past TAT in cell I disappears, however, then I hit the space bar and the Past TAT reappears. But now there is no number or formula in cell H. So I am not sure what is going on. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help: I need a function for finding next cell vertically with value | Excel Worksheet Functions | |||
revealing the contents of a formula | Excel Worksheet Functions | |||
ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Get current cell with VBA function | Excel Worksheet Functions |