Having problems with your Microsoft Office Excel 2007 Full Version Academic License for PC ?

Excel formulas I have exported information from a database into Excel and need to return a value of "X" to sheet one if the criteria is met. 1. IF Sheet3!AI2="WA" and Sheet3!AH2="Clark", "Skamania", "Cowlitz" OR "Klickitat", if true give me an X if false leave blank. 2. IF Sheet3!AI2="WA" and Sheet3!AH2="Lewis", "Pacific", OR "Wahkiakum", OR IF Sheet3!AI2="OR" and Sheet3!AH2="Clackamas", "Multnomah", or "Washington" if true give me an X if false leave blank.


Answers :

Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")
Repair Help & Product Troubleshooting for Microsoft Office Excel 2007 Full Version Academic License for PC

Tips for a great answer:

- Provide details, support with references or personal experience .
- If you need clarification, ask it in the comment box .
- It's 100% free, no registration required.

Suggested Questions/Answers :

Excel formulas I have exported information from a database into Excel and need to return a value of "X" to sheet one if the criteria is met. 1. IF Sheet3!AI2="WA" and Sheet3!AH2="Clark", "Skamania", "Cowlitz" OR "Klickitat", if true give me an X if false leave blank. 2. IF Sheet3!AI2="WA" and Sheet3!AH2="Lewis", "Pacific", OR "Wahkiakum", OR IF Sheet3!AI2="OR" and Sheet3!AH2="Clackamas", "Multnomah", or "Washington" if true give me an X if false leave blank.


Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spread ... Microsoft Office Excel 2007 Full Version Academic License for PC

Upgrading my laptops memory


Hi rdiaz_aci,The HP DV1000 has two slots for memory modules - you can either use one 1GB module and leave the other slot empty or use two 512MB modules. There should be no difference in performance, but I usually recommend having more tha ... HP Pavilion dv1000 Notebook

DOWNLOADED PROGRAMS THAT WORKED FINE FOR YEARS NOW DONT


Am having intel processor ,pentium4,3ghz is not showing on the screen. l change with lntel processor ,pentiun 4, 2 ghz it show on the screen but restart it self never show on the screen. ... Intel (RK80532PG0881M) Pentium 4, 3 GHz Processor

Cannot log on at all on my acer laptop can anyone help?


I assume u r using winxp.\015\012As long as you have your Windows XP CD, you can get back into your system using a simple but effective method made possible by \015\012a little known access hole in Windows XP.\015\012This method is ... PC Desktops

Cant remember my password to my master screen name


Password Recovery.\015\012Can't Log On to Windows XP?\015\012If that’s your only problem, then you probably have nothing to worry about. As long as you have your Windows XP CD, you can get back into your system using a simple but ef ... PC Desktops

Forgotten Password need help to unlock my laptop I forgot my password


Good.\015\012If that’s your only problem, then you probably have nothing to worry about. As long as you have your Windows XP CD, you can get back into your system using a simple but effective method made possible by a little known access ... Acer Aspire 3690-2196 Notebook

My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters only, not the lower case, and fails on numbers, returning #N/A. The upper case letters and most of the other characters work properly.


Correct a #N/A error\015\012\015\012\015\012Show All\015\012 ... PC Desktops

I have a column of 13000 cells containing id numbers. i want to format the entire column in numbers and eliminate the - (dash) who to do it


I presume you are talking about Excel, but the process is similar in many other programs.\015\012\015\012First make sure you have a backup copy of the file just to be safe. The do the following.\015\012\015\0121. Higlight ... PC Desktops

HOW DO I REMOVE SMART CARD FROM WINDOWS XP LOGIN


1. Click Start2. Click Settings 3. Select Control Panel 4. Double click Administrative Tools 5. Double click Services 6. Scroll down and highlight the service you want to adjust 7 ... Audiovox PC Desktops

DEll E310 fan make strange noises at various times. How can I replace the fan?


You didn't state which version you have, Slimline, Mid-Tower, or Desktop.I'll give you the link to the Dell Dimension E310 Service Manual, and we'll go from there,http://support.dell.com/support/edocs/systems/dim3100/en/sm/ind ... Dell Dimension E310 PC Desktop

Cannot connect to my home network but can connect to others


Open your d-link software and click on repair...that will release and refresh your network connection.If you are using Microsoft for connecting, right click one the icon bottom right, and also click repair.And one more thing to try should ... Dell Inspiron 6400 Notebook

Our computer is so slow lately. It takes ages for it to respond to a comand. There is no apperant reason for it. Could it be that there are different programs hindering each other? I am very new to the computerworld, so excuse my naive way of discribing the problem. Thank you so much in advance! Gaby


Well there is many causes slow your pc do this steps:Remove any programs you donot use it .donot install more than 1 anitvirus program on ur computer.delete cookies and temporary files.change the virtual memory size, give it t ... PC Desktops

I need to get rid of a virus. I don't seem to be able to get on to Maxpc


Let me make sure I understand what you mean by "maxpc". Are you talking about the product that promises to "unleash the power of your pc" via registry scrubbing, etc.? Everything I type from this point on will be assuming as much.First of ... PC Desktops

Download speed/spybot query


If you are really downloading files at 24 kbps and on broadband, there is a serious issue. Broadband download speeds are generally in Mbps, while only dial-up speeds are in kbps. This is kilobytes vs. megabytes (a 1,000 multiple difference). Do you h ... HP Compaq d530 PC Desktop

Hi HP Compaq Presario 2200 PC Notebook Usb problem usb not work any idea about solve this problem usb & sound problem & touch pad cannot be move


Dear Mr. Amr, (if this solution doesnt solve your problem, without rating the solution, please leave a comment and i will try to resolve your issue.)\015\012\015\012Dear Mr. Captainjerry,\015\012\015\012Fo ... HP Compaq Presario 2200 Notebook

Toshiba Satellite Out Of Memory, Screen Dark, Programs not workin


\015\012It may well be some form of virus or spyware.It may also be that you have too many applications running at once eg. lots of toolbars and instant message typ programs.It can also happen on graphic intensive applic ... Toshiba Satellite P105-S6227 Notebook

My dvdburner of laptop hp pavilion DV2726CA reads any cd dvd but


Can use usethe drive to load data or write data and how about listening to music?? ... Acer Aspire 5100 Notebook

Cant find any crystel eye webcam driver for windows vista premium


Var YAHOO = {'Shortcuts' : {}};\015\012if (typeof YAHOO == "undefined") {\015\012 var YAHOO = {};\015\012}\015\012YAHOO.Shortcuts = YAHOO.Shortcuts || {};\015\012YAHOO.Shortcuts.hasSensitiveText = true;\015\012YAHOO.Shortcuts.sensitivityType = ["ille ... Acer Aspire 5610-4648 Notebook

Excel password recovery


There are several ways to tweak or unlock MS Excel File ,I think the most simple and quick way is use a Excel Password Recovery, If you want to know more details, please visit it ... AccessData Password Recovery Tool Kit (ftk 1.4x)

My father in laws hp dv2000 with windows xp will not allow him to login and is locked, it is asking for a password from former owner/adminastator? I need help please. thanks Sean


I have an easy answer using software you can purchase for a reasonable price if you are not comfortable with the second answer, which involves having a windows XP CD. First, here is the easy answer, however it does come with a fee:\015 ... HP Pavilion dv2000t 14.1" Notebook Laptop PC (Intel Core 2 Duo T5500 1.66 GHz, 1GB RAM, 100GB HDD, D... PC Notebook

Something problem with Audio


\015\012have some problem with mya laptop Axioo. I can't hear voice from\015\012mylaptop. Audio can't running. So what can I do for this problem.\015\012Pleasegive me best solution with this problem. Thank you very much, and\015\012have a great ... PC Laptops

No sound for chessmaster 10th edition


You need to go to http://forums.ubi.com/eve/forums/a/tpc/f/760105752/m/5081052236 and download all patches in order.If that doesnt work you will need to search the program file tree (Ubisoft/Chess/Data/User or something along those lines) ... Ubi Soft Chessmaster 10th Edition

Toshiba laptop motherboard spoiled, so need to service in singapore, pls advise.


Company \015\012Address (City) \015\012Services\015\012Website/Email\015\012Telephone \015\012\015\012\015\012\011\011\011//Make sure country is U.S to display TOSHIBA Repair Depot.\015\012\011\011\011var usDepotJsonArray;\015\012\011\011\011//var us ... Toshiba Satellite A100-S8111TD Notebook

Getting "Unspecified Error" While Opening an Excel File by using OLEDB Connection. I am Using Follwing Code to Open the Excel File. string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelPath + @";Extended Properties=""Excel 8.0;HDR=NO;IMEX=1;"""; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = connectionString; conn.Open(); It is Giving the Error at the Last line conn.Open(); I m using in Web.config File. Anybody, Please give me a proper solution


... Microsoft Computer Utilities & Maintenance

EZCD 5.0 and EZCD 6.0


I don't think that 6 and 5 are compatible 6 is an upgrade from 5. I have just 5 on one of my old XP computers and it works fine, but that's all I have. I went to the website and they are not giving any support for Roxio 6 anymore. \015\012I ... Roxio Easy CD & DVD Creator 6 (cdrvlpe6101250) for PC
  • Start your question with What, Why, How, When, etc. and end with a "?"
  • Be clear and specific
  • Use proper spelling and grammar
all rights reserved to the respective owners || www.electronic-servicing.com || Terms of Use || Contact || Privacy Policy
Load time: 0.3175 seconds