KEMBAR78
If and If Nested | PDF
Scribd
Upload
55 views7 pages

If and If Nested

The document contains a table with information about different fruits including their color, whether they are an apple, and whether they are green. It shows that an apple with a green color is identified as a green apple. It also contains tables with people's names and salaries to check if they are less than 40,000, and apps with their revenue to categorize based on revenue thresholds.

Uploaded by

Preeti Anand
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
55 views7 pages

If and If Nested

The document contains a table with information about different fruits including their color, whether they are an apple, and whether they are green. It shows that an apple with a green color is identified as a green apple. It also contains tables with people's names and salaries to check if they are less than 40,000, and apps with their revenue to categorize based on revenue thresholds.

Uploaded by

Preeti Anand
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
You are on page 1/ 7

Fruit Color Is it a Apple? Is it Green? Is it a Green Apple?

Orange Orange 0 No 0
Apple Red 1 No 0
Lemon Yellow 0 No 0
Apple Green 1 Yes 1
Mango Orange 0 No 0
Lime Green 0 Yes 0
Is it a Green or an Apple?
0 #NAME?
1 #NAME?
0 #NAME?
1 #NAME?
0 #NAME?
1 #NAME?
Lucy ₹ 350,000 No
Arnold ₹ 50,000 No
Jason ₹ 65,000 No
Blake ₹ 125,000 No
Canon ₹ 30,000 It is less than 40000
Apps Revenue Revenue >15000 then Good Revenue >15000 and <25000
Twitter 20000 Bad Good
Instagram 15000 Bad
Zomato 7000 Bad
Uber Eats 30000 Good
Facebook 40000 Good
Whatsapp 17000 Bad Good

If=When we have one condition if(and)=When we have 2 conditions


Revenue>15000 and <25000 then Good ,
Revenue >=25000 is Exceptional Revenue >=25000 or <15000 then "Flag"
20000
15000 Flag
7000 Flag
Exceptional Flag
Good Flag
17000

2 if when 2 or more conditions OR= When we have Different statements


Revenue >15000 then
Apps Revenue Good Revenue >15000 and <25000
Twitter 20000 Good Good
Instagram 15000 Bad
Zomato 7000 Bad
Uber Eats 30000 Good
Facebook 40000 Good
Whatsapp 17000 Good Good
Revenue>15000 and <25000 then
Good , Revenue >=25000 is Revenue >=25000 or <15000
Exceptional then "Flag"
Good

Flag
Exceptional Flag
Exceptional Flag
Good

You might also like