Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Use of IF AND OR multiple conditions in excel

1. I agreed to these rules
Join Date
31st March 2005
Posts
4

## Use of IF AND OR multiple conditions in excel

You are about to test the values of several cells by using the following types of formulas: AND, OR, and IFs.

Input this formula into I40:

You are interested in knowing IF the logical test of an AND statement that cosists of a zero,one, and another one(use the ordinal number value) , is true or false.

The result of this And statement, if true is another IF statement that has B10 as the logical test, the word true for the true argument and false for the false argument.

The false argument is another IF statement that has B11 as the logical test, then 1 followed by a 0 for the true and false arguments respectively. The answer o that If statement is one of three argument in an OR statement. The other two arguments are the words True or False .

Now the result of this Or is the logical test of an IF that has "CGS2531 is Great!" as its true argument and "CGS2531 is the Best!" as its false argument.

Tried to clear that up a bit. I need the formula for I40. Where I am running into a problem is testing to see if three values are true or false. I can't make IF(0 AND 1 AND 1, x,y), or even IF(0 AND 1,x,y) for that matter. I don't know how to test this. Any help would be appreciated, ASAP. Thanks all.

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Use of IF AND OR multiple conditions in excel

The syntax would be IF(AND(0,1,1),x,y)

Excel Video Tutorials / Excel Dashboards Reports

3. I agreed to these rules
Join Date
31st March 2005
Posts
4

## Re: Use of IF AND OR multiple conditions in excel

thanks... obviously i haven't had much experience with excel formulas

Excel Video Tutorials / Excel Dashboards Reports

4. I agreed to these rules
Join Date
24th November 2012
Posts
1

## Re: Use of IF AND OR multiple conditions in excel

I need help! i need a formula that tells me, IF (E3<1000, 0.09, 0.085) but alsoo IF (E3<2500,0.085 ,0.08) but alsoo IF (E3<4000, 0.08, 0.075) | SO basically this are ranges... dunno how to explain it to Excel help please!

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: Use of IF AND OR multiple conditions in excel

Hi pregunton,

Welcome to the Ozgrid community.

Do not post your question in threads started by others - - this is known as thread hijacking.
Always start a new thread for *YOUR* question. If you find it helpful to clarify your needs you can include a link to this ( or any other ) thread.

When starting a new thread be sure to give it a search-friendly title that aptly describes your need.
Thanks.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno