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:

3 Answers

Which site is well renowned for writing the perfect personal statement?


Writing personal statement is very Easy task.You can get personal statement help from some online providers.But every sites are not so trusted.I you need good statement then you can contact with this site.this is more trusted. http://www.premieressay.com/personal-statement-help

Jan 11, 2014 | Things Remembered Personalized Mariposa...

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

Runtime error 365


This is a VB error right?

All i can advice is remove the unload from the event. in case, you can add a timer in your form, in the click event start the timer, and remove the objects in the Timer event (and remember to stop the Timer)


And while scanning for more solution, i bumped into this site and here's a solution that i think might help you.

  • There is an Unload statement in the Paint event for the form or for a control on the form that has the Paint event. Remove the Unload statement from the Paint event.
  • There is an Unload statement in the Change, Click, or DropDown events of a ComboBox. Remove the Unload statement from the event.
  • There is an Unload statement in the Scroll event of an HScrollBar or VScrollBar control. Remove the Unload statement from the event.
  • There is an Unload statement in the Resize event of a Data, Form, MDIForm, or PictureBox control. Remove the Unload statement from the event.
  • There is an Unload statement in the Resize event of an MDIForm that is trying to unload an MDI child form. Remove the Unload statement from the event.
  • There is an Unload statement in the RePosition event or Validate event of a Data control. Remove the Unload statement from the event.
  • There is an Unload statement in the ObjectMove event of an OLE Container control. Remove the Unload statement from the event.

Mar 28, 2010 | Acer Aspire 55421462 Notebook

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

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

112 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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