Scribd Logo
Upload

Welcome to Scribd!

  • 48 views

    Hurdle To Extend Credit: Credit Rating Out of 10 Test: Customer Credit Rating Extend Credit?

    Uploaded by

    Nadeem Akhter
    The document discusses Excel functions like IF, AND, and OR that allow logical tests to determine the value returned in a cell. It provides examples of using each function individually and in combination. The IF function returns one value if a logical test is true and another if false. The AND function returns true only if all logical tests are true, while the OR function returns true if any single test is true. The examples demonstrate applying these functions to determine whether customers qualify for an extension of credit based on their credit rating and sales.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Hurdle To Extend Credit: Credit Rating Out of 10 Test: Customer Credit Rating Extend Credit?

    Uploaded by

    Nadeem Akhter
    48 views4 pages
    The document discusses Excel functions like IF, AND, and OR that allow logical tests to determine the value returned in a cell. It provides examples of using each function individually and in combination. The IF function returns one value if a logical test is true and another if false. The AND function returns true only if all logical tests are true, while the OR function returns true if any single test is true. The examples demonstrate applying these functions to determine whether customers qualify for an extension of credit based on their credit rating and sales.

    Original Description:

    if statement

    Original Title

    If Statement1

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses Excel functions like IF, AND, and OR that allow logical tests to determine the value returned in a cell. It provides examples of using each function individually and in combination. The IF function returns one value if a logical test is true and another if false. The AND function returns true only if all logical tests are true, while the OR function returns true if any single test is true. The examples demonstrate applying these functions to determine whether customers qualify for an extension of credit based on their credit rating and sales.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    48 views4 pages

    Hurdle To Extend Credit: Credit Rating Out of 10 Test: Customer Credit Rating Extend Credit?

    Uploaded by

    Nadeem Akhter
    The document discusses Excel functions like IF, AND, and OR that allow logical tests to determine the value returned in a cell. It provides examples of using each function individually and in combination. The IF function returns one value if a logical test is true and another if false. The AND function returns true only if all logical tests are true, while the OR function returns true if any single test is true. The examples demonstrate applying these functions to determine whether customers qualify for an extension of credit based on their credit rating and sales.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4

    IF Function: Put 1 of 2 things into a cell based on a logical test

    AND Function: When all logical tests are passed, AND delivers a TRUE
    If any one of the tests come out FALSE, AND delivers a FALSE
    OR Function: When at least 1 logical tests is passed, OR delivers a TRUE
    If any one of the tests come out TRUE, OR delivers a TRUE

    Example 1: IF function
    Example 2: AND function with 2 logical tests inside IF function
    Example 3: OR function with 2 logical tests inside IF function
    Example 4: AND function with 3 logical tests inside IF function
    Example 5: AND and OR Functions to create a "None" Logical Test
    Example 6: AND and OR Functions to create a complex Logical Test

    IF Function when there is only 1 Logical Test


    Hurdle to Extend Credit:
    Credit Rating 6 out of 10
    Test:
    1 Condition Must Be Met To Extend Credit Credit Rating >= 6
    Customer Credit Rating Extend Credit?
    Customer 1 4.0
    Customer 2 5.5
    Customer 3 6.0
    Customer 4 3.0
    Customer 5 6.2

    IF Function with AND Function when there are 2 Logical Tests


    Hurdle to Extend Credit:
    Credit Rating 6
    Sales $500,000.00

    2 Conditions/Criteria Must Be Met To Extend Credit Test:


    Customer Credit Rating Last Years Sales Extend Credit? Credit Rating >= 6
    Customer 1 4.0 $1,043,462.00 AND
    Customer 2 5.5 $792,157.00 Sales >= 500000
    Customer 3 6.0 $831,594.00
    Customer 4 3.0 $335,410.00
    Customer 5 6.2 $490,000.00

    IF Function with OR Function when there are 2 Logical Tests, but only 1 must be true
    Hurdle to Extend Credit:
    Credit Rating 6
    Sales $500,000.00
    1 Condition or the other or both ("At Least 1") Must Be Met To Extend
    Credit Test:
    Customer Credit Rating Last Years Sales Extend Credit? Credit Rating >= 6
    Customer 1 4.0 $1,043,462.00 OR
    Customer 2 5.5 $792,157.00 Sales >= 500000
    Customer 3 6.0 $831,594.00
    Customer 4 3.0 $335,410.00
    Customer 5 6.2 $490,000.00

    IF Function with AND Function when there are 3 Logical Tests


    Hurdle to Extend Credit: Test:
    Credit Rating 1 6 out of 10 Credit Rating 1 >= 6
    Sales $500,000.00 AND Sales >= 500000
    Credit Rating 2 2.5 out of 5 AND Credit Rating 2 > 2.5

    3 Conditions/Criteria Must Be Met To Extend Credit


    Customer Credit Rating 1 Credit Rating 2 Last Years Sales Extend Credit?
    Customer 1 4.0 1.3 $1,043,462.00
    Customer 2 6.0 2.7 $792,157.00
    Customer 3 7.0 2.6 $831,594.00
    Customer 4 3.0 1.4 $335,410.00
    Customer 5 6.2 3.2 $490,000.00

    IF Function with AND and OR Function


    Hurdle to Extend Credit: Test:
    Credit Rating 1 6 out of 10 Credit Rating 1 >= 6
    Sales $500,000.00 AND
    Credit Rating 2 2.5 out of 5 Sales >= 500000
    OR
    Credit Rating 2 > 2.5
    1 Conditions Must Be Met and at Least One Of The Other Two Tests Must Be Met To Extend
    Credit
    Customer Credit Rating 1 Credit Rating 2 Last Years Sales Extend Credit?
    Customer 1 4.0 1.3 $1,043,462.00
    Customer 2 6.0 2.7 $792,157.00
    Customer 3 7.0 2.6 $831,594.00
    Customer 4 3.0 1.4 $335,410.00
    Customer 5 6.2 3.2 $490,000.00
    Credit Rating >= 6

    Sales >= 500000


    Credit Rating >= 6

    Sales >= 500000

    You might also like