Students Marks Scored Result For passing min 50 marks required
Student1 41 Using If function assign Pass or Fail
Student2 27
Student3 50
Student4 72
Student5 90
Student6 98
Student7 46
Student8 48
Student9 77
Student10 98
Student11 93
Commission Table
Name Sales Amount Commission
Calculate Commission Amount if the sales amount is 1
than 150000. Rate of commission is 2% on sales amoun
Virat 203073 the commission value up to 2 decimals.
Anil 173277
Abhishek 220660
Chintu 98000
Nilesh 100843
Siddharth 223270
Vivek 214780
Amit 236138
Raj 142627
=IFERROR(ROUND(IF(C4>=150000,C4*2%,"Work Hard"),2),"Work Hard")
Amount if the sales amount is 150000 or greater
ommission is 2% on sales amount. Also Round of
up to 2 decimals.
2),"Work Hard")
0 49 Fail
Students Marks Scored Grade 50 60 C
Student1 41 61 70 B
Student2 27 71 85 A
Student3 50 86 100 A+
Student4 72
Student5 90 Using Nested if assign the Grades
Student6 98
Student7 46
Student8 48
Student9 77
Student10 98
Student11 93
cutoff price
cut1 500 ₹ 3.00 price1
cut2 1200 ₹ 2.70 price2
cut3 2000 ₹ 2.30 price3
Given Table
₹ 2.00 price4
Order Table
order quantity cost per unit cost
475
900 Order Table
1450
2100
In this example we want to create a table where as
the order quantity increase the price per unit will
iven Table change at different quantity cut off levels.
From the given table data we have to create a new table
using if condition where we will only type the order
quantity and we get the total cost and the price per unit
as per the cut off level
Commission Table
Name Seat Covers LED Lamps Alooy Wheels Total Sales Commission
Virat 43263 71914 71697 186874
Anil 48035 71932 38070 158037
Abhishek 53527 89550 68368 201445
Chintu 75787 55417 79852 191056
Nilesh 60720 79026 47738 187484
Siddharth 60453 50517 89982 199952
Vivek 78351 48032 85975 212358
Amit 76552 89933 29107 195592
Raj 72311 51174 76398 199883
=IF(AND(C4>=50000,D4>=50000,E4>=50000),F4*2%,"Work Hard")
Calculate Commission Amount if the sales amount is 50000 or greater
than 50000 for each product. Rate of commission is 2% on Total sales
amount.
k Hard")
Commission Table
Name Seat Covers LED Lamps Alooy Wheels Total Sales Commission
Virat 43263 71914 71697 186874
Anil 48035 21932 38070 158037
Abhishek 53527 89550 68368 201445
Chintu 35787 45417 39852 191056
Nilesh 60720 79026 47738 187484
Siddharth 60453 50517 89982 199952
Vivek 48351 48032 45975 212358
Amit 76552 89933 29107 195592
Raj 32311 21174 26398 199883
=IF(OR(C4>=50000,D4>=50000,E4>=50000),F4*2%,"Work Hard")
Calculate Commission Amount if the sales amount is 50000 or greater
than 50000 for any one product. Rate of commission is 2% on Total sales
amount.
Segment Country Product Flag If product is sold in Government or Enterprise Se
Government Canada Carretera
Government Germany Carretera
Midmarket France Carretera
Midmarket Germany Carretera
Midmarket Mexico Carretera
Government Germany Carretera
Midmarket Germany Montana
Channel Partners Canada Montana
Government France Montana
Channel Partners Germany Montana
Midmarket Mexico Montana
Enterprise Canada Montana
Small Business Mexico Montana
Government Germany Montana
Enterprise Canada Montana
Midmarket United States of America Montana
Government Canada Paseo
Midmarket Mexico Paseo
Channel Partners Canada Paseo
Government Germany Paseo
Channel Partners Germany Paseo
Government Mexico Paseo
Midmarket France Paseo
Small Business Mexico Paseo
Midmarket Mexico Paseo
Government United States of America Paseo
Government Canada Paseo
Channel Partners United States of America Paseo
Midmarket Canada Paseo
Government Canada Paseo
Government Germany Paseo
Government Mexico Velo
Enterprise France Velo
Channel Partners Germany Velo
Government Germany Velo
Channel Partners Germany Velo
Enterprise United States of America Velo
Enterprise Canada Velo
Small Business Canada VTT
Channel Partners Germany VTT
Midmarket France VTT
Midmarket Germany VTT
Government France VTT
Small Business France VTT
Government Canada VTT
Government France Amarilla
Channel Partners United States of America Amarilla
Enterprise Germany Amarilla
Government France Amarilla
overnment or Enterprise Segment Show Flag
