| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula #value! Error,
thankyou..
"Kevin B" wrote: 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. |
| Reply |
| 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) | |||
Hybrid Mode
