Question about Computers & Internet

1 Answer

How can i use "IF" condition

How i can use "IF" condition more than 50 times in excle-2003

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 69 Answers

Only 7 IF statements can be nested in the same formula, so you'd have use 8+ cells. The syntax for IF is: =IF(logical_test,value_if_true,value_if_false)

So the maximum that can be in a single cell would look something like: =IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,value_if_true,value_if_false),value_if_false),value_if_false),value_if_false),value_if_false),value_if_false),value_if_false)

Posted on Dec 31, 2008

  • Peter Sturniolo
    Peter Sturniolo Dec 31, 2008

    And you do not have to nest each IF statment in the value_if_true spot, you can also place them in the value_if_false spot.

×

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

I want to print on lower left corner of envelope, how? I will print which office to direct mail. Probably 50 envelopes at a time.


Go to the screen where you address envelopes.

Select OPTIONS

See the Delivery Address Font Option. There is a drop down to select the distance FROM LEFT. That means from the left side of the envelope. Set that to a low distance.

Jul 06, 2011 | Microsoft Word 2003 for PC

1 Answer

I can't type anything on it, but it's not a trial. Give me answers pls.


If you did not register Office 2003, you may have used up your 50 times you can open it. Every time you open Word, Excel PowerPoint, etc. it counts as one time. If you have registered it, try reinstalling it or repairing the installation. You will need the cd's and registration code/

Feb 15, 2011 | Microsoft Office Word 2003 for PC

1 Answer

How can I download ms office 2003. I min ms word ,excl, power point.


Unless you have a subscription to TechNet from Microsoft, this cannot be downloaded.

Jan 24, 2011 | Microsoft Office Professional Edition 2003...

1 Answer

Sir i want to know about excel formulas please give me. my email.add. amarsri@hotmail.com


how can we do vlookup two sheet on excle?

E.g

Sheet1 Sheet2
Class Marks

here there are two types of Sheets.If i want to combiend two sheet via vlookup.could you teach me what should do i for same ASAP.

thaks.

Jun 25, 2009 | Microsoft Excel for PC

1 Answer

I can't open the excle sheets


Hi, u can easily open excel sheet but you should have ms office on your pc. if ms office is installed ur pc so repair or reinstall your ms office any version. thanks mukesh_ibm@yahoo.com

May 13, 2009 | Microsoft Computers & Internet

1 Answer

Conditional formating to highlight problems.


in Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.

to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.

It's slightly different in Excel 2003 so let us know what version you are using.

Cheers.

Feb 27, 2009 | Microsoft Office Standard for PC

5 Answers

Word 2007 Patch


What your Boss means is a patch for your Word 2003 so that you are able to open his Word 2007 documents. In the 2007 Office system Microsoft changed the file format .doc to .docx (An XML based document file). Word 2003 doesn't understand that since al previous versions uses the plain .doc format.

I take it this is what you need:
[Microsoft Office 2007 Compatibility Pack]

With these you should be able to open the documents he sent you.

I hope this helps. Please rate.

Greetings,

DarkNeogen.

Feb 08, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

56 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98765 Answers

David Payne
David Payne

Level 3 Expert

14065 Answers

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

Answer questions

Manuals & User Guides

Loading...