Question about Microsoft Office Standard for PC

1 Answer

If statement how do you build more than one "If" arguement in a single cell

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 6,966 Answers
Re: if statement


MS Excel's logical test (IF) by its very nature has already two (2) "IF" conditions in a cell, "if true" and "if false".
Should you want to do a series of conditions for a single logical test of a cell, you can replace the IF TRUE and IF FALSE values with other IF Condition(s) (of course the syntax must be correct with appropriate parenthesis where and when required). Formula within a formula within a formula).
Below is an example of four (4) instances of IF conditions within the initial IF formula.


Hope this be of some help/idea. Pls post back how things turned out or should you need additional information.

Good luck and kind regards.

Posted on Jan 12, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

Need a formula in excel

use if statement
where A1=T2 and B1=U2

Jul 16, 2009 | Microsoft Office Excel 2007

1 Answer

Invalid arguement in outlook express and incredmail

: Right click on start > Open all users

2: Choose tools> Folder options> File types

3: Check the file association for *.eml

4) Change the association to Outlook Express

5) Test Outlook express

Mar 23, 2009 | Microsoft Office Outlook 2007: Windows

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

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How can i use "IF" condition

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)

Dec 31, 2008 | Business & Productivity Software

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

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

2 Answers

What function can make a text/string BOLD?

Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.
I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.
Glad to be of assistance - please rate the posting - I can learn from you.

Oct 26, 2008 | Microsoft Office 2003 Basic Edition...

2 Answers

Excel function


The simplest solution is to use the if function.
In your example you coudl use:


IF "girl" is in a1 then b2 would show as 1.
If anything else but "girl" is in a1 then b2 would show as 0.

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

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 | Business & Productivity Software

1 Answer


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 Standard for PC Logo

Related Topics:

103 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides