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
Word macro that can call cells out of Excel for a find and replace 0
VBA Export to PDF 0
Macro to Select text from a point given to a specific word 2
Making a macro only work on certain files 2
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
inlineShape.OLEFormat.Activate() command fails for excel file 0
VBA for Dependents shortcut menu 0

Top