If(and Function
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View If(and Function as PDF for free.
More details
- Words: 842
- Pages: 11
Comparison on the basis of a single fixed value Name Marks Result Nawaz 56 Pass Pervaiz 77 Pass Shams 45 Pass Asad 34 Fail Amjid 33 Fail Jahangir 22 Fail khan 56 Pass imran 67 Pass wahid 75 Pass jamil 34 Fail salim 33 Fail
Comparison of Variable Values
Mobile Nokia Samsung LG Dell Sun Sony Ericson Nokia Nokia Nokia Dell Dell Dell Dell Dell Sony Ericson Sony Ericson Samsung
Akhestal Cost
Type
kharsawal Price Loss/Proft 700 1200 Gatta 1230 3400 Gatta 3456 1200 Tawan 1200 12000 Gatta Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan
3310 1234 3432 2334 2233 2233 4433 223 2223 1223 323 4423 2322 23423 23231 1222 122
Comparison on the basis of text Name Nawaz Pervaiz Shams Asad Amjid Jahangir
Post teacher engineer engineer engineer doctor accounts
Salary 1000 1200 1400 1600 1800 2000
Bonus Total 2000 0 0 0 0 0
3000 1200 1400 1600 1800 2000
khan imran wahid jamil salim
doctor doctor accounts accounts teacher
2200 2400 2600 2800 3000
Name Urud English Maths Islamiat PS
Total marks Smarks 100 100 100 50 70
0 0 0 0 2000
2200 2400 2600 2800 5000
Pass/Fail 34 Fail 34 Fail 56 Pass 18 Pass 34 Pass
Comparison with percentage% Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
And Or Not
Name Nawaz Pervaiz Shams
Urud
English 45 34 33 23 44 55 44 23 33 56 77
Maths 87 67 55 45 55 44 33 44 34 56 65
Islamiat
Smarks
45 66 55 45 34 44 34 33 44 34 34
34 33 44 32 32 11 12 34 23 22 32
45 66 55
Islamiat Result 45 Pass 33 Fail 44 Fail
<>
Urud
English 45 34 33
Maths 87 67 55
211 200 187 145 165 154 123 134 134 168 208
TotalMarks 350 350 350 350 350 350 350 350 350 350 350
Asad Amjid Jahangir khan imran wahid jamil salim
23 44 55 44 23 33 56 77
45 55 44 33 44 34 56 65
45 34 44 34 33 44 34 34
32 Fail 32 Fail 11 Fail 12 Fail 34 Fail 23 Fail 22 Fail 32 Fail
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Post teacher teacher teacher doctor doctor doctor doctor engineer engineer engineer teacher
Experience Salary Netsalary 3 1000 1000 5 2000 3000 6 3000 4500 7 4000 4000 6 5000 5000 5 6000 6000 5 7000 7000 4 8000 8000 3 9000 9000 4 10000 10000 5 11000 16500
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Job salesman salesman salesman salesman salesman salesman salesman salesman salesman salesman salesman
Sales
Area NetSalary 40000 Peshawar 20000 50000 Peshawar 25000 23000 Peshawar 3000 39000 Mardan 3000 30000 Mardan 3000 20000 Mardan 3000 50000 Lahore 3000 60000 Lahore 3000 50000 Lahore 3000 30000 karachi 3000 40000 karachi 3000
Excessive Amount Capital Expenses Date Type 1/1/2002 Raw Material 1/1/2002 Make Up 1/1/2002 food 1/1/2002 Fuel 1/1/2002 Books
140000 Balance
Amount 23000 10000 7000 100000 50000
Date Ref 1/1/2002 1/1/2002 1/1/2002 5/30/2009 5/30/2009
Funds Amount 101 100000 103 80000 104 100000 105 50000 106 200000
1/1/2002 Medicine 5/30/2009 Carwash 5/30/2009 Car fixing 5/30/2009 Fuel
100000 30000 20000 200000
6/2/2009
107
150000
Pass/Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
nds
140000
And Or Not
<>
Start of "And" function Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Urdu
English
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Psot teacher teacher teacher engineer engineer engineer teacher doctor doctor doctor teacher
40 34 30 450 40 20 80 50 50 40 40
Islamiat 35 50 50 40 50 50 70 70 30 35 50
Maths 50 60 60 35 45 30 65 30 60 45 30
Result 65 pass 70 fail 40 fail 50 pass 40 pass 60 fail 50 pass 50 fail 50 fail 50 pass 50 fail
Salary Experience Net Salary 1000 3 1200 5 360 1400 2 1600 6 1800 7 2000 4 2200 3 2400 4 2600 3 2800 5 3000 4 900
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Job Sales Area Salesman 40000 Peshawar Salesman 60000 Peshawar Salesman 50000 Karachi Salesman 30000 Karachi Salesman 40000 Karachi Salesman 30000 Peshawar Salesman 60000 Lahore Salesman 70000 Lahore Salesman 55000 Lahore Salesman 65000 Karachi Salesman 40000 Peshawar
Net salary 20000 30000 3000 3000 3000 3000 3000 3000 3000 3000 20000
Acxessive amount
Capital
150000 Balance Funds
Expenses Date Type Amount 5/30/2009 Raw material 100000 5/30/2009 fuel 50000 5/30/2009 cars rate 50000 5/30/2009 fuel 100000 5/30/2009 Raw material 200000 5/30/2009 fuel 50000 5/30/2009 Raw material 500000
Date Ref 5/30/2009 5/30/2009 5/30/2009 5/30/2009
101 102 103 104
Amount 200000 100000 300000 300000
Excessive Amount
Capital Expenses Date Type Amount 6/2/2009 Fuel 50000 6/2/2009 Raw material 100000 6/2/2009 Wages 40000 6/2/2009 Car wash 20000
90000Balance Funds Date Ref 6/2/2009 6/2/2009
101 102
Amount 100000 200000
Comparison of Variable Values
Mobile Nokia Samsung LG Dell Sun Sony Ericson Nokia Nokia Nokia Dell Dell Dell Dell Dell Sony Ericson Sony Ericson Samsung
Akhestal Cost
Type
kharsawal Price Loss/Proft 700 1200 Gatta 1230 3400 Gatta 3456 1200 Tawan 1200 12000 Gatta Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan Tawan
3310 1234 3432 2334 2233 2233 4433 223 2223 1223 323 4423 2322 23423 23231 1222 122
Comparison on the basis of text Name Nawaz Pervaiz Shams Asad Amjid Jahangir
Post teacher engineer engineer engineer doctor accounts
Salary 1000 1200 1400 1600 1800 2000
Bonus Total 2000 0 0 0 0 0
3000 1200 1400 1600 1800 2000
khan imran wahid jamil salim
doctor doctor accounts accounts teacher
2200 2400 2600 2800 3000
Name Urud English Maths Islamiat PS
Total marks Smarks 100 100 100 50 70
0 0 0 0 2000
2200 2400 2600 2800 5000
Pass/Fail 34 Fail 34 Fail 56 Pass 18 Pass 34 Pass
Comparison with percentage% Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
And Or Not
Name Nawaz Pervaiz Shams
Urud
English 45 34 33 23 44 55 44 23 33 56 77
Maths 87 67 55 45 55 44 33 44 34 56 65
Islamiat
Smarks
45 66 55 45 34 44 34 33 44 34 34
34 33 44 32 32 11 12 34 23 22 32
45 66 55
Islamiat Result 45 Pass 33 Fail 44 Fail
<>
Urud
English 45 34 33
Maths 87 67 55
211 200 187 145 165 154 123 134 134 168 208
TotalMarks 350 350 350 350 350 350 350 350 350 350 350
Asad Amjid Jahangir khan imran wahid jamil salim
23 44 55 44 23 33 56 77
45 55 44 33 44 34 56 65
45 34 44 34 33 44 34 34
32 Fail 32 Fail 11 Fail 12 Fail 34 Fail 23 Fail 22 Fail 32 Fail
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Post teacher teacher teacher doctor doctor doctor doctor engineer engineer engineer teacher
Experience Salary Netsalary 3 1000 1000 5 2000 3000 6 3000 4500 7 4000 4000 6 5000 5000 5 6000 6000 5 7000 7000 4 8000 8000 3 9000 9000 4 10000 10000 5 11000 16500
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Job salesman salesman salesman salesman salesman salesman salesman salesman salesman salesman salesman
Sales
Area NetSalary 40000 Peshawar 20000 50000 Peshawar 25000 23000 Peshawar 3000 39000 Mardan 3000 30000 Mardan 3000 20000 Mardan 3000 50000 Lahore 3000 60000 Lahore 3000 50000 Lahore 3000 30000 karachi 3000 40000 karachi 3000
Excessive Amount Capital Expenses Date Type 1/1/2002 Raw Material 1/1/2002 Make Up 1/1/2002 food 1/1/2002 Fuel 1/1/2002 Books
140000 Balance
Amount 23000 10000 7000 100000 50000
Date Ref 1/1/2002 1/1/2002 1/1/2002 5/30/2009 5/30/2009
Funds Amount 101 100000 103 80000 104 100000 105 50000 106 200000
1/1/2002 Medicine 5/30/2009 Carwash 5/30/2009 Car fixing 5/30/2009 Fuel
100000 30000 20000 200000
6/2/2009
107
150000
Pass/Fail Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass Pass
nds
140000
And Or Not
<>
Start of "And" function Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Urdu
English
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Psot teacher teacher teacher engineer engineer engineer teacher doctor doctor doctor teacher
40 34 30 450 40 20 80 50 50 40 40
Islamiat 35 50 50 40 50 50 70 70 30 35 50
Maths 50 60 60 35 45 30 65 30 60 45 30
Result 65 pass 70 fail 40 fail 50 pass 40 pass 60 fail 50 pass 50 fail 50 fail 50 pass 50 fail
Salary Experience Net Salary 1000 3 1200 5 360 1400 2 1600 6 1800 7 2000 4 2200 3 2400 4 2600 3 2800 5 3000 4 900
Name Nawaz Pervaiz Shams Asad Amjid Jahangir khan imran wahid jamil salim
Job Sales Area Salesman 40000 Peshawar Salesman 60000 Peshawar Salesman 50000 Karachi Salesman 30000 Karachi Salesman 40000 Karachi Salesman 30000 Peshawar Salesman 60000 Lahore Salesman 70000 Lahore Salesman 55000 Lahore Salesman 65000 Karachi Salesman 40000 Peshawar
Net salary 20000 30000 3000 3000 3000 3000 3000 3000 3000 3000 20000
Acxessive amount
Capital
150000 Balance Funds
Expenses Date Type Amount 5/30/2009 Raw material 100000 5/30/2009 fuel 50000 5/30/2009 cars rate 50000 5/30/2009 fuel 100000 5/30/2009 Raw material 200000 5/30/2009 fuel 50000 5/30/2009 Raw material 500000
Date Ref 5/30/2009 5/30/2009 5/30/2009 5/30/2009
101 102 103 104
Amount 200000 100000 300000 300000
Excessive Amount
Capital Expenses Date Type Amount 6/2/2009 Fuel 50000 6/2/2009 Raw material 100000 6/2/2009 Wages 40000 6/2/2009 Car wash 20000
90000Balance Funds Date Ref 6/2/2009 6/2/2009
101 102
Amount 100000 200000
Related Documents
07 Excel Ifand
November 2019 11
Function
December 2019 67
Function
November 2019 54
Function
June 2020 25
Function Webquest
June 2020 10