Scribd
Upload
82 views13 pages

Lesson-9-Logical Functions

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.

Uploaded by

petermyintsoe5687
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
82 views13 pages

Lesson-9-Logical Functions

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.

Uploaded by

petermyintsoe5687
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

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