Microsoft Office Standard for PC Logo

Related Topics:

Posted on Jan 12, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

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

Answer This Question
  • troyb Jan 15, 2008

    Great Fix- Thanks!

×

1 Answer

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
Brigadier General:

An expert that has over 10,000 points.

  • Master 6,966 Answers
  • Posted on Jan 12, 2008
Anonymous
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
Brigadier General:

An expert that has over 10,000 points.

Joined: Apr 06, 2007
Answers
6966
Questions
17
Helped
3089334
Points
19604

Hi,

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.

=IF(H7>4.21,H1,(IF(H7>3.4,I1,(IF(H7>2.6,J1,(IF(H7>1.8,M1,(IF(H7>0.99,O1,O7)))))))))

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.

  • Anonymous Jan 15, 2008

    Hi again,

    Appreciate the rating and glad to be of assistance.

    Cheers.

×

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
3answers

My certificate of occupancy which has been cleared with the building inspector is now being held up because my survey has shown over clearing.
This is the Computers and Internet section of Fixya
Read full answer
Dec 23, 2017 • The Computers & Internet
0helpful
1answer

If you were a financial planner, what are some Excel functions that you might use or need? Please be specific, and explain thoroughly. You may need to use the Internet for answers, so remember to include...
Hi Eward,

Here you go:

1) Simple Balance Sheet:
2) Statement of Owner's Equity:

3) Single Step Income Statement:


And lot's of example Financial Excel templates:
http://www.exinfm.com/free_spreadsheets.html

Financial Functions in Excel reference:
http://office.microsoft.com/en-001/excel-help/financial-functions-reference-HP010342519.aspx
Read full answer
Jun 28, 2014 • Computers & Internet
0helpful
3answers

What grade of oil do air compessors use
iso 32 // 30wt. compressor oil, or no additive mineral oil, never use automotive oil in a air compressor
Read full answer
May 06, 2014 • Eagle C5160v1 - Single Stage - 5hp 60...
0helpful
1answer

What is the use of open curly braces in turbo c?
Curly braces are used in C (Turbo and otherwise) to group statements. A group of statements inside a pair of curly braces is treated semantically as a single statement. For example, a for-loop controls one statement. If you want more than one statement within the loop, you use curly braces to group them together.
Read full answer
Mar 06, 2010 • Microsoft Computers & Internet
0helpful
2answers

My phone won't charge
1. its either the battery or the charger.
2. you could visit the dealer to check your phone`s battery is ok, and /or try another charger.
Hope i`ve been a help.
Read full answer
Nov 15, 2009 • AT&T Sony Ericsson W580i Cell Phone -...
0helpful
1answer

Need a code to unlock my blackberry 8900 from tmobile. would appreciate any help. thanks
You can call tmobile to get it unlocked but it is differcult to unlock phones so you might get into an arguement with the company
or you can go to google and look for codes or buy an unlocking code off the internet
Read full answer
Jul 27, 2009 • Cell Phones
0helpful
2answers

C++ problem
When it comes to else, if, or else-if statements, once you understand how they work you will be laughing. It is not very difficult to understand, and for all C/C++ programmers (New or Experienced alike) I would suggest reading the information and tutorials located at http://www.cprogramming.com/tutorial.html

This is a great resource site for any C/C++ programmers out there, especially if you have been single tasked and forgot how to do something.
Read full answer
Feb 13, 2009 • Microsoft Computers & Internet
0helpful
1answer

When i try to get songs from my pc it doesnt work
your phones bluetooth may not be on or fully connected, try the good old usb cable, purchased seperatly, but i can almost garentee it will work.
Read full answer
Dec 31, 2008 • LG Shine KE970 Cellular Phone
0helpful
1answer

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)
Read full answer
Dec 31, 2008 • Computers & Internet
0helpful
2answers

Excel function
an2net21,

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

=IF(A1="girl",1,0)

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.
Read full answer
Feb 25, 2008 • Microsoft Office Professional 2007 Full...
Not finding what you are looking for?

View Most Popular

Office Standard for PC

  • Computers & Internet

Related Question

My certificate of occupancy which has been cleared with the building inspector is now being held up because my survey has shown over clearing.

  • The Computers & Internet

Related Topics

143 views

Ask a Question

Usually answered in minutes!

Popular Questions

Get message that "Setup cannot find Office.en-us\OfficeMUI.msi"

Microsoft Office Professional 2007...

Hi i need micro soft visio 2010 product key

Microsoft Office Standard for PC

PROBLEM OF PRO11.MSI

Microsoft Office 2003 Pro...

HOW TO DOWNLOAD MS OFFICE 2007 FULL VERSION FREE

Microsoft Office Professional 2007...

Confirmation code

Microsoft Office Professional 2007...

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...