Complex formula change making m,e crazy

Giganews Newsgroups
Subject: Complex formula change making m,e crazy
Posted by:  John Corbin (JohnHabsF…@gmail.com)
Date: Thu, 3 Jul 2008

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 ?

Replies