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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula #value! Error,
Try:
=IF(TODAY()=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)),dd", if no day in text then 1....first of month HTH JG "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. |
#4
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula #value! Error,
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")) "pinmaster" wrote: Try: =IF(TODAY()=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)),dd", if no day in text then 1....first of month HTH JG "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) |