Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula #value! Error,
Got this far, don't know how to negate #Value! error, in equation: (thanks)
=IF(TODAY()=DATE(MID(T9,2,2)+100,MID(T9,4,2),MID( T9,6,2)-$H$7)),"dd", to do with, if not have :yymmdd in left of general text cell T9... or even if the dd portion is not present. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
formula too long error | Excel Discussion (Misc queries) | |||
Simplifying array formula which evaluates as error. | Excel Worksheet Functions | |||
Formula syntax error - chinese and gibberish | Excel Discussion (Misc queries) | |||
Formula error... | Excel Discussion (Misc queries) |