Help with using the IF and Mid functions
 

Hi

I was hoping sombody could look at my formual and tell me were im going
wrong.

I have a number in I38 and depending on the value (1,2 or 3) it splits
the Text in H38 acordingly

=IF(I38=1,MID(H38,1,1),IF(I38=2,MID(H38,2,1),MID(H 38,3,1)))

Any pointers to were i have gone wrong would be great

Thanks


--
haitch2
------------------------------------------------------------------------
haitch2's Profile: http://www.excelforum.com/member.php...o&userid=27677
View this thread: http://www.excelforum.com/showthread...hreadid=474626

What about: =MID(H38,I38,1)

Hope this helps
Rowan

haitch2 wrote:
Hi

I was hoping sombody could look at my formual and tell me were im going
wrong.

I have a number in I38 and depending on the value (1,2 or 3) it splits
the Text in H38 acordingly

=IF(I38=1,MID(H38,1,1),IF(I38=2,MID(H38,2,1),MID(H 38,3,1)))

Any pointers to were i have gone wrong would be great

Thanks