This formula resolves to TRUE: =NOT(ISNUMBER(RIGH(V670,5)))

V670 is a string of numbers formatted as text.

As far as I can tell, ISNUMBER(RIGHT(V670,5)) resolves to FALSE
because the extracted string of characters is formatted as text.

Therefore the NOT portion forces the formula to resolve to TRUE
because it is TRUE that the string is NOT a number?

Does that sound accurate?

On Oct 10, 9:47 am, Dave F wrote:
This formula resolves to TRUE: =NOT(ISNUMBER(RIGH(V670,5)))

V670 is a string of numbers formatted as text.

As far as I can tell, ISNUMBER(RIGHT(V670,5)) resolves to FALSE
because the extracted string of characters is formatted as text.

Therefore the NOT portion forces the formula to resolve to TRUE
because it is TRUE that the string is NOT a number?

Does that sound accurate?

Should be RIGHT not RIGH in the formula.

TRUE, but why are you using it? Why not skip the NOT and use ISTEXT instead?


--


Regards,


Peo Sjoblom





"Dave F" wrote in message
ups.com...
This formula resolves to TRUE: =NOT(ISNUMBER(RIGH(V670,5)))

V670 is a string of numbers formatted as text.

As far as I can tell, ISNUMBER(RIGHT(V670,5)) resolves to FALSE
because the extracted string of characters is formatted as text.

Therefore the NOT portion forces the formula to resolve to TRUE
because it is TRUE that the string is NOT a number?

Does that sound accurate?

You're correct.

You could also use

=ISNUMBER(-RIGHT(V670,5))

(assuming V670 isn't blank)

If you want the opposite behavior, one way:

=NOT(ISNUMBER(-RIGHT(V670,5)))


In article . com,
Dave F wrote:

This formula resolves to TRUE: =NOT(ISNUMBER(RIGH(V670,5)))

V670 is a string of numbers formatted as text.

As far as I can tell, ISNUMBER(RIGHT(V670,5)) resolves to FALSE
because the extracted string of characters is formatted as text.

Therefore the NOT portion forces the formula to resolve to TRUE
because it is TRUE that the string is NOT a number?

Does that sound accurate?

Well, fair point, but the formula is in a spreadsheet given to me by
someone else. So I didn't create it.

Dave

On Oct 10, 9:58 am, "Peo Sjoblom" wrote:
TRUE, but why are you using it? Why not skip the NOT and use ISTEXT instead?

--

Regards,

Peo Sjoblom

"Dave F" wrote in message

ups.com...



This formula resolves to TRUE: =NOT(ISNUMBER(RIGH(V670,5)))

V670 is a string of numbers formatted as text.

As far as I can tell, ISNUMBER(RIGHT(V670,5)) resolves to FALSE
because the extracted string of characters is formatted as text.

Therefore the NOT portion forces the formula to resolve to TRUE
because it is TRUE that the string is NOT a number?

Does that sound accurate?- Hide quoted text -

- Show quoted text -