Announcement

Collapse
No announcement yet.

Use of IF AND OR multiple conditions in excel

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

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

    The syntax would be IF(AND(0,1,1),x,y)
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

    Comment


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

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

      Comment


      • #4
        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!

        Comment


        • #5


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

          Forum Rules | Message to Cross Posters | How to use Tags

          Comment

          Working...
          X