| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding an unintended value
if I9 does not have a date then J9 read "118 Years, 0 months, 18days and I want it to be blank. Any help would be greatly appreciated. I tried the basics but then just a FALSE reading.
J9 Formula: =IF(K9<"","Placed Out of Service",(DATEDIF(I9,NOW(),"y")&" years, "&DATEDIF(I9,NOW(),"ym")&" months, "&DATEDIF(I9,NOW(),"md")&" days")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unintended line connecting two data points | Charts and Charting in Excel | |||
| unintended format changes Excel 2007 | Excel Discussion (Misc queries) | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| Hiding Column Also hiding text | Excel Programming | |||
| #DIV/0! hiding | Excel Discussion (Misc queries) | |||
Threaded Mode
