Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 38

Bad result

176.51 H083 02/01/2007 0:00 HAUL 1081 6.5 P 601 41805 H TGH6.51

=IF(LEFT(I63,2)="41","TGH"&MID(A63,3,5),I63)

I have this formula attached to this line and the result should be TGH805
instead it comes out TGH6.51 can anyone please explain. Thanks

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
vlookup shows result one cell above the expected result	Marie	Excel Worksheet Functions	7	November 14th 06 02:52 AM
excel result return wrong calcuation result	garyww	Excel Worksheet Functions	1	August 14th 06 11:14 AM
excel result return wrong calcuation result	garyww	Excel Worksheet Functions	0	August 14th 06 05:02 AM
Advanced formula - Return result & Show Cell Reference of result	Irv	Excel Worksheet Functions	7	May 6th 06 03:36 AM
vlookup based on random result returns incorrect result	rickat	Excel Worksheet Functions	1	December 6th 05 01:16 PM

All times are GMT +1. The time now is 10:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us