9)if person age is greater than 25 give 8500 salary and if his age is less than
25 give 5500 salary ..
examples for if conditions
Name Age Salary
rosel 45 8500
minak 25 5500
tina 22 5500
kiran 65 8500
minal 25 5500
hina 21 5500
lina 25 5500
dina 35 8500
10)for the folowing data find wheter the person is eligible to vote or not
name Age eligible to vote or not
Eena 18 eligible to vote
Mina 15 not eligible
Dina 22 eligible to vote
Lina 65 eligible to vote
55 eligible to vote
11)for the following data find wheter the child is eligible to take admission
in the school or not
name Age yes/no
Rahul 5 YES
Sonal 3.5 NO
Ritu 5 YES
Heena 4 NO
Sindu 8 YES
Vinnu 6 YES
13)exampl
Roll no Name of the student Kannad English
10001 Vilas 45 85
10002 Nitin 65 45
10003 Mrudula 95 45
10004 Heena 74 84
10005 Tina 65 45
10006 Dina 74 85
10007 Kiran 52 45
10008 Minal 74 75
10009 Veena 74 45
10010 Nirgun 68 72
14)example for if(and)condition
Name Boys age Girls age Eligible or not
ajay &kajal 45 25 Eligible to marry
salman&katrina 45 17 Not eligible to marry
dharnnu&hema 20 40 Not eligible to marry
amitab&jaya 55 45 Eligible to marry
sharukh &gouri 28 16 Not eligible to marry
johan&biphasha 28 55 Eligible to marry
15)If(And)
Name Age average eligible/not
Raju 17 74 not eligible for job
heena 28 55 not eligible for job
mina 35 65 eligible for job
tina 20 80 not eligible for job
kiran 32 65 eligible for job
rohit 24 42 not eligible for job
rahul 42 65 eligible for job
16)if(and)
name nationality country code age
raju Indian 18 19
minal Indian 18 17
kiran american 1 25
john england 2 22
jakky american 1 35
kittu Indian 18 35
17)if(and)
Name Working days out of 30 days performance performance
Vilas 28 78 very good
Nitin 20 65 bad
Mrudula 12 48 bad
Heena 15 75 bad
Tina 27 65 very good
Dina 29 65 very good
Kiran 22 25 bad
Minal 26 22 bad
Veena 27 23 bad
Nirgun 24 88 bad
18)examples for if(not)
Name Old number new number repeated or not
we 71200 9500 not repeated
you 4560 4500 not repeated
minal 8500 8200 not repeated
kiran 35640 35640 repeated
ritu 9866 9856 not repeated
hina 3566 3562 not repeated
lina 4780 4780 repeated
19)sumif and countif
branch month sales
margo jan 3254
bangalore jan 1234
mumbai feb 2546
mumbai mar 3241
mangalor apr 2145
hubli feb 2134
hubli mar 2451
margao feb 5464
mangalor apr 3456
bangalore feb 4521
bangalore apr 4215
mumbai may 1234
mumbai mar 2451
index
Top Products Part no`s flight reg price
mobiles 1001 25 25
camera 1002 30 45
watches 1003 25 55
cosmetics 1004 35 45
shooes 1005 30 65
laptop 1006 40 75
perfumes 1007 1 85
clothes 1008 5 75
ifconditions
12)fix commission to the salesman according to their sales amount
salesa name amount
Vindhya 4500
Soumya 2500
Asha 6520
Disha 3520
Lisha 4500
Vinash 2580
Avinash 3560
13)examples for if(or) student report
Hindi Maths
45 75
74 75
20 85
75 85
54 65
75 45
42 85
85 45
75 85
73 84
1)find whether these pairs are eligible to marry or not
2)boys age should be greater than 21& girls age must be gre
Formula is =if(and(
d) 1)find whether the candidate is eligib
Eligible for vote or not
not
Eligible for vote
Not eligible for vote 2)condition is that candidate country
Not eligible for vote
Not eligible for vote
should be greater than 18.
Not eligible for vote
3) formula is=if(and(
2)condition is that candidate country
should be greater than 18.
Eligible for vote 3) formula is=if(and(
1)give the performance as very good and bad
2)if workers working days should be greater than 25 and his
performance should be greater than 65% give condition as
very good if not give condition as bad.
sum if sales only if city name is mumbai
9472 1)Sum if sales only if city na
sum if sales only if month is march
8143 2)sum if sales only if month
sum if sales if it is ABOVE 3000
24151 3)sum if sales if it is above
count of mumbai city
4)count of Mumbai city
5)count of January month
3)sum if sales if it is above
4)count of Mumbai city
4
count of jan month
5)count of January month
2
count of sales above 2500
6)count of sales above 250
7
their sales amount
commssion
5% commission
2% commission
5% commission
2% commission
5% commission
2% commission
2% commission
eport
Sci Sst Totl Average Grade
85 75 410 68.3333333333333 First class
85 75 419 69.8333333333333 First class
75 85 405 67.5 Fail
25 85 428 71.3333333333333 Fail
75 75 379 63.1666666666667 First class
95 72 446 74.3333333333333 distingtion
45 72 341 56.8333333333333 Second class
75 75 429 71.5 distingtion
75 85 439 73.1666666666667 distingtion
85.5 45 427.5 71.25 distingtion
gible to marry or not
1& girls age must be greater than 18
d whether the candidate is eligible to vote for the country or
ndition is that candidate country code should be 18 and age
d be greater than 18.
mula is=if(and(
ndition is that candidate country code should be 18 and age
d be greater than 18.
mula is=if(and(
n 25 and his
ondition as
um if sales only if city name is Mumbai
um if sales only if month is march
um if sales if it is above 3000
ount of Mumbai city
ount of January month
um if sales if it is above 3000
ount of Mumbai city
ount of January month
ount of sales above 2500
