Help with using the IF and Mid functions

  • Thread starter Thread starter haitch2
  • Start date Start date
H

haitch2

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(H38,3,1)))

Any pointers to were i have gone wrong would be great

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with IF function 3
IP Subnet Calculator - Excel Function 1
Using Mid Function with Pivot Table Calculated Item 0
If , Mid or right functions or a combination thereoff. 3
Problem with MID (any text) Command 2
Nested IF and MID functions 2
Cannot format data after using mid() function 3
MID and FIND Function for Numbers 2

Back
Top