Excel Function . . . Continued

C

Charlie

Now that I am able to pull the value of the character out of the string. I
need to use an IF statement to have TRUE/FALSE text returned.

=IF(MID(M3,8,2)=1,"1/8 NPT","1/4 NPT") This returns a False value, would you
know why?
M3 = AP10-FG1A1P
 
J

Jacob Skaria

MID(),LEFT(),RIGHT() are Text functions..You need to have double quotes around/

=IF(MID(M3,8,2)="1","1/8 NPT","1/4 NPT")

If this post helps click Yes
 

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

Excel Functions 6
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
False error when trying to return data in datagrid 1
Value if an if statement is false 3
Out of Stack Space error 2
Function to put worksheet name in cell returns text, need number 5
Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
Discovering No-BREAK Space in cell Data 4

Top