Question about Microsoft Office Excel 2003 for PC

# LENGHTY IF STATEMENT

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

Posted by on

Ad

## 2 Answers

• Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

Night Owl:

An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

• Contributor
• 52 Answers

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

Ad
• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor
• 20 Answers

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

Ad

## 1 Suggested Answer

• 2 Answers

Hi,
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.
Good luck!

Posted on Jan 02, 2017

## Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

## Related Questions:

3 Answers

### How do i write a thesis statement on tween cyberbulling?

Writing essay is a difficult task. Writers need proper understanding on essay; here basically the writers need to write the essay in a proper manner, like first introduction, then body paragraph and at last the conclusion. If you write the introduction and body part successfully, conclusion writing is just like summarizing all the main points that already written in rest essay part. So writers have to sum up the content what you've write on the complete essay. Be specific and honest in writing a paper. Ask feedback from your friends and family. Also you can have help from custom essay writing service.
Custom Essay Writing Dissertation Writing Thesis Writing with Free Draft...

Mar 09, 2015 | Computers & Internet

1 Answer

### Bank Book Statement

Do you have a question? If you want to access your bank statement online, try your bank's website. FixYa certainly has no access to your private financial data.

Feb 26, 2013 | Computers & Internet

1 Answer

### When I copy my bank statement into a word doc and try to edit it, it locks up for 30 seconds or so every time I press enter to move a line of print down. Should I remove and download my office 2007 again?

Hi, If it only happens with your bank statement then the problem is not with Word. Try pasting the statement into the document using the "Paste Special" option and paste as Text or other format.
Try to see if there are any hidden lines in the document.
Regards, Icom1

Feb 01, 2011 | Microsoft Office Word 2007 Full Version...

1 Answer

### I have a document that has a table in it and within that table I've written an IF statement. This doc is loaded in another software that when executed it will display data based on fields that are inputted...

the option that i can c is try keep the statement in another worksheet in the same workbook and re-frace/re-work ur formula....if can send me the file then i can have a look at that... i have been using various spreadsheets since 1986, begning from lotus123/QuatroPro then XL....
so have fair idea how it may be worked out...
send it to suresh_krishnan1961@yahoo.com

Dec 17, 2009 | Computers & Internet

1 Answer

### Need Formula

TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. \$
SQL Database Migration \$
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! \$
CSV Converter \$

IMPORTING
Import SQL Into Excel-SQL Tester \$
Import Excel Into Access \$

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

2 Answers

### SQL Invalid cursor number 135 error

The error is being generated because you are trying to order on a value not in your selected fields e.g EFFECTIVE_DATE

You only have TRANSACTION_TYPE in your select statement

Sep 24, 2008 | Gupta Team Developer for PC

1 Answer

### Adobe photoshop elements 2.0 Plus photoshop album 2.0 serial numbers

Hi there!

As i understand you has lost your serial number and are trying to install Adobe on a new PC.

Have you ever registered your product online? Do you still have the original receipt? If so, call Adobe Customer Support and they would help you.
Next you could call your distributor from whom you bought the package(frys) and ask him for the receipt number or the serial number if he has the copy.
This statement is taken from Adobe site
"If you cannot find your serial number and it is not in our registration database, Adobe can reissue your serial number in certain cases. This applies only to current shipping versions of Adobe branded or Macromedia branded products, and one version prior to the current version. Please contact Adobe Customer Service with a copy of your Proof of Purchase "

Click on the link to find the above Statement,
http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_15292&sliceId=2

Click on the below link to find Customer Service in your country and region,

http://www.adobe.com/support/contact/

Regards,

Olafsson.

Aug 18, 2008 | Adobe Photoshop Elements 2.0 for PC

1 Answer

### Excel

Why not do it directly with the if statement? ie In Cell c56 put the following formula: if(c54="PT6agi",2.88,if(c54="PT45jal",2.6,if(c54=....)))

Sep 10, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

114 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

2970 Answers

Level 3 Expert

528 Answers

Level 3 Expert

18419 Answers

Loading...