software

Got this far, don't know how to negate #Value! error, in equation: (thanks)

=IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),MID( T9,6,2)-$H$7)),quot;ddquot;,

to do with, if not have :yymmdd in left of general text cell T9... or even
if the dd portion is not present.

You can use a variation of the following formula to change the error result
of a formula, but it requires that you write the formula twice, once as a
condition, and once as the false result:

=IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formul a_To_Evaluate)Here is another expample, using the PMT function.

=IF(ISERROR(PMT(H1,H2,H3)),quot;Missing Required Valuesquot;,PMT(H1,H2,H3))

Hope this helps
--
Kevin Backmannquot;nastechquot; wrote:

gt; Got this far, don't know how to negate #Value! error, in equation: (thanks)
gt;
gt; =IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),MID( T9,6,2)-$H$7)),quot;ddquot;,
gt;
gt; to do with, if not have :yymmdd in left of general text cell T9... or even
gt; if the dd portion is not present.

Try:

=IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),IF(I SERROR(MID(T9,6,2)-$H$7),1,MID(T9,6,2)-$H7)),ddquot;,
if no day in text then 1....first of month

HTH
JG

quot;nastechquot; wrote:

gt; Got this far, don't know how to negate #Value! error, in equation: (thanks)
gt;
gt; =IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),MID( T9,6,2)-$H$7)),quot;ddquot;,
gt;
gt; to do with, if not have :yymmdd in left of general text cell T9... or even
gt; if the dd portion is not present.

thankyou..

quot;Kevin Bquot; wrote:

gt; You can use a variation of the following formula to change the error result
gt; of a formula, but it requires that you write the formula twice, once as a
gt; condition, and once as the false result:
gt;
gt; =IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formul a_To_Evaluate)
gt;
gt;
gt; Here is another expample, using the PMT function.
gt;
gt; =IF(ISERROR(PMT(H1,H2,H3)),quot;Missing Required Valuesquot;,PMT(H1,H2,H3))
gt;
gt; Hope this helps
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Got this far, don't know how to negate #Value! error, in equation: (thanks)
gt; gt;
gt; gt; =IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),MID( T9,6,2)-$H$7)),quot;ddquot;,
gt; gt;
gt; gt; to do with, if not have :yymmdd in left of general text cell T9... or even
gt; gt; if the dd portion is not present.

thankyou, will look at later, i'm just novic, but mother necessity:
=IF(LEFT(T9,2)lt;gt;quot;:0quot;,quot;quot;,IF(AND(MIN(AK9:AO9)lt;1,LEFT (T9,1)=quot;:quot;,TODAY()gt;DATE(MID(T9,2,2) 100,MID(T9,4,2 ),MID(T9,6,2)-$H$7)),quot;ddquot;))

quot;pinmasterquot; wrote:

gt; Try:
gt;
gt; =IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),IF(I SERROR(MID(T9,6,2)-$H$7),1,MID(T9,6,2)-$H7)),ddquot;,
gt; if no day in text then 1....first of month
gt;
gt; HTH
gt; JG
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Got this far, don't know how to negate #Value! error, in equation: (thanks)
gt; gt;
gt; gt; =IF(TODAY()gt;=DATE(MID(T9,2,2) 100,MID(T9,4,2),MID( T9,6,2)-$H$7)),quot;ddquot;,
gt; gt;
gt; gt; to do with, if not have :yymmdd in left of general text cell T9... or even
gt; gt; if the dd portion is not present.