Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Lesson-9-Logical Functions

    Uploaded by

    petermyintsoe5687
    The document contains examples and exercises demonstrating logical formulas and functions in Excel including AND, OR, IF statements. It shows how to use logical formulas to evaluate test scores and calculate exam results as pass or fail. It also contains an example of calculating sales bonuses based on sales amounts and products.

    Copyright:

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

    Lesson-9-Logical Functions

    Uploaded by

    petermyintsoe5687
    28 views13 pages
    The document contains examples and exercises demonstrating logical formulas and functions in Excel including AND, OR, IF statements. It shows how to use logical formulas to evaluate test scores and calculate exam results as pass or fail. It also contains an example of calculating sales bonuses based on sales amounts and products.

    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 contains examples and exercises demonstrating logical formulas and functions in Excel including AND, OR, IF statements. It shows how to use logical formulas to evaluate test scores and calculate exam results as pass or fail. It also contains an example of calculating sales bonuses based on sales amounts and products.

    Copyright:

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

    Lesson-9-Logical Functions

    Uploaded by

    petermyintsoe5687
    The document contains examples and exercises demonstrating logical formulas and functions in Excel including AND, OR, IF statements. It shows how to use logical formulas to evaluate test scores and calculate exam results as pass or fail. It also contains an example of calculating sales bonuses based on sales amounts and products.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 13

    10 20 Formulas Result Excellence Business Center

    =A2>B2 0 1- Greater than > 09-255568517, 09-402529374


    =B2>=A2 1 2- Greater than or equal to >= Logical Functions
    =A2<B2 1 3- Less than <
    Basic Test
    =B2<=A2 0 4- Less than or equal to <=
    =A2=B2 0 5- Equal =
    =A2<>B2 1 6- Not equal to <>
    ce Business Center
    8517, 09-402529374
    gical Functions
    Exercise-1 Excellence Business Cen
    Exam Exam Result
    No Name
    Marks
    Formula
    (P/F)
    09-255568517, 09-40252

    1 Thida Naing 50 =IF(C3>=40,"Pass","Fail") Pass


    2 Mya Mya 30 =IF(C4>=40,"Pass","Fail") Fail Pass ဘက္မွ ေရးထားေသာ Formula

    3 Aung Aung 45 =IF(C5>=40,"Pass","Fail") Pass


    4 Maung Win 100 =IF(C6>=40,"Pass","Fail") Pass
    5 Aung Min 70 =IF(C7>=40,"Pass","Fail") Pass
    6 Lin Lin Maw 25 =IF(C8>=40,"Pass","Fail") Fail
    7 Naing Win 90 =IF(C9>=40,"Pass","Fail") Pass

    Exam Exam Result


    No Name Formula Fail ဘက္မွ ေရးထားေသာ Formula
    Marks (P/F)

    1 Thida Naing 50 =IF(C12<40,"Fail","Pass") Pass


    2 Mya Mya 30 =IF(C13<40,"Fail","Pass") Fail
    3 Aung Aung 45 =IF(C14<40,"Fail","Pass") Pass
    4 Maung Win 100 =IF(C15<40,"Fail","Pass") Pass
    5 Aung Min 70 =IF(C16<40,"Fail","Pass") Pass
    6 Lin Lin Maw 25 =IF(C17<40,"Fail","Pass") Fail
    7 Naing Win 90 =IF(C18<40,"Fail","Pass") Pass

    Exercise-2

    Exam
    No Name Formula Distinction
    Marks Distinction ဘက္မွ ေရးထားေသာ
    Formula
    1 Thida Naing 50 =IF(C21>=80,"Distinction","-") -
    2 Mya Mya 30 =IF(C22>=80,"Distinction","-") -
    3 Aung Aung 45 =IF(C23>=80,"Distinction","-") -
    4 Maung Win 100 =IF(C24>=80,"Distinction","-") Distinction
    5 Aung Min 70 =IF(C25>=80,"Distinction","-") -
    6 Lin Lin Maw 25 =IF(C26>=80,"Distinction","-") -
    7 Naing Win 90 =IF(C27>=80,"Distinction","-") Distinction
    Excellence Business Center

    09-255568517, 09-402529374
    No Project Name Budget Amount Actual Cost Budget Over
    1 Project-A 5,500,000 5,800,000 Budget Over
    2 Project-B 6,500,000 6,300,000
    3 Project-C 2,800,000 2,900,000 Budget Over
    4 Project-D 3,800,000 3,750,000
    5 Project-E 4,500,000 4,700,000 Budget Over
    6 Project-F 4,300,000 4,400,000 Budget Over
    7 Project-G 4,000,000 3,800,000
    Total 31,400,000 31,650,000
    Lesson-2.1 Excellence Business Cen
    Exam Exam Result
    No Name
    Marks
    Formula
    (P/F)
    09-255568517, 09-40252

    1 Thida Naing 50 =IF(C3>=40,"Pass","Fail") Pass


    2 Mya Mya 30 =IF(C4>=40,"Pass","Fail") Fail
    3 Aung Aung 45 =IF(C5>=40,"Pass","Fail") Pass
    4 Maung Win 100 =IF(C6>=40,"Pass","Fail") Pass
    5 Aung Min 70 =IF(C7>=40,"Pass","Fail") Pass
    6 Lin Lin Maw 25 =IF(C8>=40,"Pass","Fail") Fail
    7 Naing Win 90 =IF(C9>=40,"Pass","Fail") Pass
    Excellence Business Center

    09-255568517, 09-402529374
    10 20 Formulas Result AND, OR
    =AND(A1<5,B1>A1) 0
    AND
    =AND(5<A1,A1<B1,B1=A1*2) 1 Excellence Business Center
    =OR(A1<5,B1>A1) 1 09-255568517, 09-402529374
    OR
    =OR(A1<5,B1<A1,B1=A1*4) 0 Logical Functions
    ence Business Center
    568517, 09-402529374
    Logical Functions
    Marks

    Myanmar

    Chemitry
    No Student Name

    English

    Biology
    Physics
    Math

    Total
    1 Mg Aung Aung 75 75 87 70 80 80 467

    2 Ma Thuzar Moe 40 22 80 45 40 47 274

    3 Mg Naing Lin 45 75 75 80 74 56 405

    4 Ma Shwe Phoo 66 38 56 47 54 49 310

    5 Ma Sein Moh 45 40 47 80 45 56 313


    Marks

    Formula Result

    =IF(AND(C3>=40,D3>=40,E3>=40,F3>=40,G3>=40,H3>=40),"Pass","Fail") Pass

    =IF(AND(C4>=40,D4>=40,E4>=40,F4>=40,G4>=40,H4>=40),"Pass","Fail") Fail

    =IF(AND(C5>=40,D5>=40,E5>=40,F5>=40,G5>=40,H5>=40),"Pass","Fail") Pass

    =IF(AND(C6>=40,D6>=40,E6>=40,F6>=40,G6>=40,H6>=40),"Pass","Fail") Fail

    =IF(AND(C7>=40,D7>=40,E7>=40,F7>=40,G7>=40,H7>=40),"Pass","Fail") Pass
    Excellence Business Center

    09-255568517, 09-402529374

    Logical Functions
    No Sales Person Sales Product Sales Amount Bonus for Product B (>=250000)
    1 Ko Ko Aung Product A 450000 0
    2 Marlar Aung Product B 380000 15000
    3 Thuzar Myint Product A 700000 0
    4 Paing Soe Aung Product B 250000 15000
    5 Myint Myat Thu Product A 300000 0
    6 Naing Win Product A 340000 0
    7 Sabal Product B 200000 0
    8 Rose Product B 260000 15000

    You might also like