Bad result
Arlene,
I can't explain what's going wrong because I cant see what is in the cells
your formula refers to but if this helps this is what you formula is doing:-
If the 2 leftmost characters of I63 are 41 then put TGH and 5 characters out
of A63 starting at the 3rd character.
So to get the result you expect
I63 must contain 41xxxxx where x is anything
A63 must contain xx805 where likewise x is anything and there is nothing
after the 5.
Mike
"Arlene" wrote:
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
|