If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

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.

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!

Re: Use of IF AND OR multiple conditions in excel

Hi pregunton,

Welcome to the Ozgrid community.

Please take some time to read the Forum Rules.

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.