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 09, 2015 | Computers & Internet
Feb 01, 2011 | Microsoft Office Word 2007 Full Version...
Dec 17, 2009 | Computers & Internet
Dec 15, 2008 | Microsoft Windows XP Home Edition
Aug 18, 2008 | Adobe Photoshop Elements 2.0 for PC
114 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: