Formula #value! Error,

[nastech]

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.

 

[Kevin B]

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,Formula_To_Evaluate)


Here is another expample, using the PMT function.

=IF(ISERROR(PMT(H1,H2,H3)),"Missing Required Values",PMT(H1,H2,H3))

Hope this helps

 

[pinmaster]

Try:

=IF(TODAY()>=DATE(MID(T9,2,2)+100,MID(T9,4,2),IF(ISERROR(MID(T9,6,2)-$H$7),1,MID(T9,6,2)-$H7)),dd",
if no day in text then 1....first of month

HTH
JG

 

[nastech]

thankyou..

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,Formula_To_Evaluate)


Here is another expample, using the PMT function.

=IF(ISERROR(PMT(H1,H2,H3)),"Missing Required Values",PMT(H1,H2,H3))

Hope this helps

 

[nastech]

thankyou, will look at later, i'm just novic, but mother necessity:
=IF(LEFT(T9,2)<>":0","",IF(AND(MIN(AK9:AO9)<1,LEFT(T9,1)=":",TODAY()>DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd"))