I am working on an if and statement that is not understanding a cell with both text and numbers. I am trying to meet certain conditions with and statement also there is alot of conditons.
example:
a1=G110581f or N110582f or 110582f
a2=pool or customer or retired or gfe
a3= N or G or O or L
in other words if a1 begins with g and a2 is pool or retired and a3 is g then statement is true.
The trick y part is also on one instatnce a1 should begin with N and the second character should not be a number 1 through 9.
When I do this is does not recongize the second character on whether there is an = or <>.
hope this gives enough info to assist.
jesse
There are several functions you should know about: text(A1), value(A1), isnumber(A1), istext(A1)
so you can do something like
=if( and(value(left(a1))="N",isnumber(value(mid(a1,2,1))=false , RESULT)
To find the second character in a string in A1 use =mid(A2,2,1)
To check if it is a number use =isnumber(value(mid(A2,2,1)))
I hope this helps to get past the part you are stuck on - not being familiar with your problem it's difficult to give you any more advice.
149 views
Usually answered in minutes!
×