If In If Formullas
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 In If Formullas as PDF for free.
More details
- Words: 622
- Pages: 6
Multiple If/Nested if /If N if/If within if Nested ifs cannot be more than 7 Names Marks Grade ihsan 56 C khan 78 B imran 55 C wahid 44 Pass rafi 33 Fail shams 32 Fail asad 33 Fail perviaz 45 C Muskan 67 C Hashmat 89 A Amjid 87 A Jahangir 44 Pass Sabir 32 Fail Asad 12 Fail
Fees 800 800 800 800 800 800 800 800 800 800 800 800 800 800
Scholarship 720 640 720 800 800 800 800 720 720 560 560 800 800 800
Name ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Post Teacher Teacher Teacher Doctor Doctor Teacher Teacher engineer Teacher Teacher Doctor Teacher engineer engineer
Salary Bonus 10000 12000 14000 16000 18000 20000 22000 24000 26000 28000 30000 32000 34000 36000
NetTotal 3000 13000 3600 15600 4200 18200 3200 19200 3600 21600 6000 26000 6600 28600 2400 26400 7800 33800 8400 36400 6000 36000 9600 41600 3400 37400 3600 39600
Name ihsan khan imran wahid rafi shams asad
Job Sales Performance Total Salesman 30000 Good 9000 Salesman 49000 Super 19600 Salesman 30000 Good 9000 Salesman 23000 Fair 4600 Salesman 23000 Fair 4600 Salesman 15000 Poor Per 1500 Salesman 43000 Super 17200
perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Salesman Salesman Salesman Salesman Salesman Salesman Salesman
12000 Poor Per 34000 Good 23000 Fair 33400 Good 23200 Fair 12000 Poor Per 32300 Good
Job Name ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Post Teacher Teacher Teacher Doctor Doctor Teacher Teacher engineer Teacher Teacher Doctor Teacher engineer engineer
engineer
Salary NetTotal 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000 21000 22000 23000 24000 31200 26000 27000 28000 29000 30000 31000 32000 33000 34000 44200 36000 46800
1200 10200 4600 10020 4640 1200 9690
Multiple if / Nested if / if in if / If whitin if. Nested if can not be more than 7 times Name
Marks
ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Grade
60 56 65 80 85 70 35 45 30 25 70 75 80 35
Name
Post
ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
teacher teacher teacher engineer engineer engineer doctor doctor doctor engineer engineer teacher teacher teacher
Name
Job
ihsan khan imran wahid rafi
salseman salseman salseman salseman salseman
Fees
Scholirship
C D C A A B fail pass fail fail B B A fail
800 800 800 800 800 800 800 800 800 800 800 800 800 800 800
Salary
Bonus
8000 1200 1400 1600 1800 2000 2200 2400 2600 2800 3000 3200 3400 3600
Salse
Perfomence
30000 good 35000 good 25000 fair 40000 super 38000 good
680 800 680 600 600 640 800 800 800 800 640 640 600 800 800
Net total
1600 240 280 0 0 0 550 600 650 0 0 640 680 720
Net total
9000 10500 5000 16000 11400
9600 1440 1680 1600 1800 2000 2750 3000 3250 2800 3000 3840 4080 4320
shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
salseman salseman salseman salseman salseman salseman salseman salseman salseman
18000 poor per 40000 super 30000 good 35000 good 40000 super 25000 fair 15000 poor per 28000 fair 20000 fair
job Name
post
ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
teacher teacher teacher doctor doctor doctor doctor teacher engineer engineer engineer engineer teacher teacher
teacher
Salary
Net total
7000 1200 1400 1600 1800 2000 2200 2400 2600 2800 3000 3200 3400 3600
9100 2200 2400 2600 2800 3000 3200 3400 3600 3800 4000 4200 4400 4600
1800 16000 9000 10500 16000 5000 1500 5600 4000
if.
Fees 800 800 800 800 800 800 800 800 800 800 800 800 800 800
Scholarship 720 640 720 800 800 800 800 720 720 560 560 800 800 800
Name ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Post Teacher Teacher Teacher Doctor Doctor Teacher Teacher engineer Teacher Teacher Doctor Teacher engineer engineer
Salary Bonus 10000 12000 14000 16000 18000 20000 22000 24000 26000 28000 30000 32000 34000 36000
NetTotal 3000 13000 3600 15600 4200 18200 3200 19200 3600 21600 6000 26000 6600 28600 2400 26400 7800 33800 8400 36400 6000 36000 9600 41600 3400 37400 3600 39600
Name ihsan khan imran wahid rafi shams asad
Job Sales Performance Total Salesman 30000 Good 9000 Salesman 49000 Super 19600 Salesman 30000 Good 9000 Salesman 23000 Fair 4600 Salesman 23000 Fair 4600 Salesman 15000 Poor Per 1500 Salesman 43000 Super 17200
perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Salesman Salesman Salesman Salesman Salesman Salesman Salesman
12000 Poor Per 34000 Good 23000 Fair 33400 Good 23200 Fair 12000 Poor Per 32300 Good
Job Name ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Post Teacher Teacher Teacher Doctor Doctor Teacher Teacher engineer Teacher Teacher Doctor Teacher engineer engineer
engineer
Salary NetTotal 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000 21000 22000 23000 24000 31200 26000 27000 28000 29000 30000 31000 32000 33000 34000 44200 36000 46800
1200 10200 4600 10020 4640 1200 9690
Multiple if / Nested if / if in if / If whitin if. Nested if can not be more than 7 times Name
Marks
ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
Grade
60 56 65 80 85 70 35 45 30 25 70 75 80 35
Name
Post
ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
teacher teacher teacher engineer engineer engineer doctor doctor doctor engineer engineer teacher teacher teacher
Name
Job
ihsan khan imran wahid rafi
salseman salseman salseman salseman salseman
Fees
Scholirship
C D C A A B fail pass fail fail B B A fail
800 800 800 800 800 800 800 800 800 800 800 800 800 800 800
Salary
Bonus
8000 1200 1400 1600 1800 2000 2200 2400 2600 2800 3000 3200 3400 3600
Salse
Perfomence
30000 good 35000 good 25000 fair 40000 super 38000 good
680 800 680 600 600 640 800 800 800 800 640 640 600 800 800
Net total
1600 240 280 0 0 0 550 600 650 0 0 640 680 720
Net total
9000 10500 5000 16000 11400
9600 1440 1680 1600 1800 2000 2750 3000 3250 2800 3000 3840 4080 4320
shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
salseman salseman salseman salseman salseman salseman salseman salseman salseman
18000 poor per 40000 super 30000 good 35000 good 40000 super 25000 fair 15000 poor per 28000 fair 20000 fair
job Name
post
ihsan khan imran wahid rafi shams asad perviaz Muskan Hashmat Amjid Jahangir Sabir Asad
teacher teacher teacher doctor doctor doctor doctor teacher engineer engineer engineer engineer teacher teacher
teacher
Salary
Net total
7000 1200 1400 1600 1800 2000 2200 2400 2600 2800 3000 3200 3400 3600
9100 2200 2400 2600 2800 3000 3200 3400 3600 3800 4000 4200 4400 4600
1800 16000 9000 10500 16000 5000 1500 5600 4000
if.
