S
ScoobyDoo
Hi
I cannot get this formula to work:
=IF(ISERR(-TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))),"UNKNOWN",IF(and(--TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))>=35,(--TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))<=1859),VALUE(TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))),"UNKNOWN"))
when I put it into a cell it just shows up as text.
I formatted the cell as General and still nothing
The formula auditor says it is a constant.
the formula is supposed to take text like this:
BGN/17/48
and return the number after the last / character
can anyone help ?
J
I cannot get this formula to work:
=IF(ISERR(-TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))),"UNKNOWN",IF(and(--TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))>=35,(--TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))<=1859),VALUE(TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))),"UNKNOWN"))
when I put it into a cell it just shows up as text.
I formatted the cell as General and still nothing
The formula auditor says it is a constant.
the formula is supposed to take text like this:
BGN/17/48
and return the number after the last / character
can anyone help ?
J