Question about Microsoft Office Excel 2003 for PC
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.
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.
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)
Posted on Oct 23, 2012
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.
Posted on Mar 13, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 03, 2015 | The Computers & Internet
Mar 08, 2013 | Corel WordPerfect Computers & Internet
Mar 19, 2011 | Microsoft Office Professional 2007 Full...
Feb 01, 2011 | Microsoft Office Word 2007 Full Version...
Nov 02, 2009 | Microsoft Excel for PC
Nov 20, 2008 | Microsoft Excel for PC
Dec 05, 2007 | Computers & Internet
109 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: