Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Use of IF AND OR multiple conditions in excel

  1. #1
    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. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,422

    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. #3
    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. #4
    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. #5
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Excel Tutorial: SUMIF with Multiple Conditions » Techtites
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: July 9th, 2008, 20:48
  2. Replies: 11
    Last Post: December 13th, 2005, 10:33

Bookmarks

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