J
John Corbin
I have thsi formula...
myFormula = "=IF(ISERR(-TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))),""UNKNOWN""," _
& "IF(--TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))<999," _
& "VALUE(TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))),""UNKNOWN""))"
I got it here actually and thaknsagin..
the question I have is this, it may seem stupid but...
I need to change the < 999 part to >= 35 and <=1859....
when ever I try it I go blind trying to find the error I get..
BTW.. I know EXCEL has a formula evaluator but is there something
better out there ?
myFormula = "=IF(ISERR(-TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))),""UNKNOWN""," _
& "IF(--TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))<999," _
& "VALUE(TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))),""UNKNOWN""))"
I got it here actually and thaknsagin..
the question I have is this, it may seem stupid but...
I need to change the < 999 part to >= 35 and <=1859....
when ever I try it I go blind trying to find the error I get..
BTW.. I know EXCEL has a formula evaluator but is there something
better out there ?