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

  • troyb Jan 15, 2008

    Great Fix- Thanks!

×

Ad

1 Answer

  • 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

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.

Posted on Jan 12, 2008

  • Louie  Role
    Louie Role Jan 15, 2008

    Hi again,

    Appreciate the rating and glad to be of assistance.

    Cheers.

×

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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.

Mar 06, 2010 | Microsoft Computers & Internet

2 Answers

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.

Nov 15, 2009 | AT&T Sony Ericsson W580i Cell Phone -...

1 Answer

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

Jul 27, 2009 | Cell Phones

2 Answers

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.

Feb 13, 2009 | Microsoft Computers & Internet

1 Answer

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.

Dec 31, 2008 | LG Shine KE970 Cellular Phone

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 | Computers & Internet

2 Answers

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.

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

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

Related Topics:

112 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...