Question about Microsoft Office Excel 2003 for PC

2 Answers

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

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

  • 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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

When will I receive my next statement?


You need to contact support for Intuit. We don't have access to that information here.

Feb 29, 2016 | Intuit Quickbooks Financial Statement...

1 Answer

How should you read this passage to answer a general question? Read the thesis statement, the main ideas of the paragraphs, and the switchback words, because these will tell you what the overall thesis is...


An expository passage introduces or explains a subject, gives groundwork information that is necessary for understanding ideas, or analyzes information objectively. By analyzing the thesis statement, main ideas, and how they are interrelated (switchbacks), you can obtain a good overview of the authors perspective for the thesis.

Mar 03, 2015 | The Computers & Internet

1 Answer

Alignment of data in tables


When I started learning about these statements I had to understand the different types of the financial statements and what are their uses. There are many tools to calculate various elements like "current/fixed assets", "current/long-term liabilities and "net profit".
There are many websites which provide e-book so you can learn more about items in financial statement.

Mar 08, 2013 | Corel WordPerfect Computers & Internet

4 Answers

How to download a microsoft word in internet


If you wish to read a Microsoft Word Documet, Click This Link, to Download Word Reader, from the Microsot Web Site.

If you wish to Buy Microsoft Word, Click This Link, submit your method of payment and then download, Word 2010, also from The Microsoft Web Site.

Thank You For Choosing FixYa~!

Mar 19, 2011 | Microsoft Office Professional 2007 Full...

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...

2 Answers

Trying to write a loop using excel text boxes such as: Dim x as integer for x= 0 to 100 textbox(x).backcolor=vbWhite x=x+1 next x Not working any thoughts thanks


You don't say how your program is not working, but one of the problems with your code is where you have x=x+1. Loops using For Next don't need a statement to add 1 to the value of x. The variable x will automatically be increased by 1 each time the program reaches the Next x statement. Your program should be
Dim x as integer: For x=0 to 100: textbox(x).backcolor=vbWhite: Next x
Have fun

Nov 02, 2009 | Microsoft Excel for PC

2 Answers

Problems reconciling the bank statement


if this is for simply accounting you have to click on "save transactions for Acc. Rec"

May 11, 2009 | Computers & Internet

1 Answer

If statement that will change cell color in excel


conditional formatting is alright.

you just have to remove the $ signs in the cell reference when you set a condition.

then, copy-paste

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

Statements in QuickBooks


If you do not want your statements to reflect any payments, go to the top of your tool bar, click on Edit, go down to "Preferences", find the "Sales and Customers", go to "Company Preferences", and at the bottom you have the option to "Automaticly apply Payments", make sure that is not checked.

If this helps, please rate me. Thanks, Patty

Dec 05, 2007 | Computers & Internet

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

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

109 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...