Formula #value! Error,
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)),"Missing Required Values",PMT(H1,H2,H3))
Hope this helps
--
Kevin Backmann
"nastech" wrote:
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.
|