Posted to microsoft.public.excel.misc

Dave F[_2_] Dave F[_2_] is offline

external usenet poster

Posts: 187

=NOT(ISNUMBER(RIGH(V670,5)))

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to copy down formulars into same column by a row left to righ	Holly	Excel Discussion (Misc queries)	5	April 3rd 07 10:59 PM
ISNumber - What Context?	ronaldo444	Excel Worksheet Functions	1	August 14th 06 04:59 PM
ISNUMBER	Michael Nol	Excel Worksheet Functions	1	March 22nd 06 12:29 AM
ISNUMBER	RJJ	Excel Worksheet Functions	8	January 4th 06 11:29 PM
isnumber with sumproduct	sh0t2bts	Excel Worksheet Functions	2	November 25th 04 02:19 PM

All times are GMT +1. The time now is 11:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us