PK !q@= = [Content_Types].xmlPK ! PK !" docProps/core.xmlIFS Practice WorkbookXplorExcel.comFree IFS practice sheets with answer key — https://xplorexcel.com/ifs-function-in-excel/PK !0 docProps/app.xmlXplorExcel Practice BuilderPK ! xl/workbook.xmlPK !h h xl/_rels/workbook.xml.relsPK !bI
xl/styles.xmlPK !#Vu u xl/worksheets/sheet1.xml0
1
23
45
|
6
78
910
1112
1314
|
15
1617
1819
2021
|
2223
PK ![
# xl/worksheets/_rels/sheet1.xml.relsPK ! ܄u
u
xl/worksheets/sheet2.xml24
252627
285_xlfn.IFS(C4<=5,"Short Hop",C4<=15,"City Ride",C4<=40,"Outstation",C4>=41,"Long Haul")
2915_xlfn.IFS(C5<=5,"Short Hop",C5<=15,"City Ride",C5<=40,"Outstation",C5>=41,"Long Haul")
3030_xlfn.IFS(C6<=5,"Short Hop",C6<=15,"City Ride",C6<=40,"Outstation",C6>=41,"Long Haul")
3173_xlfn.IFS(C7<=5,"Short Hop",C7<=15,"City Ride",C7<=40,"Outstation",C7>=41,"Long Haul")
32
33
34
35
36
PK !}
xl/worksheets/sheet3.xml3738
25262739404142
43314445
28624645
4736348
4915
50151
307
5228
5391
314
5411
2940
55114
PK !>- xl/worksheets/sheet4.xml5638
5758404142
5918160
617262
635364
6515466
6740
51
PK ! c c xl/worksheets/sheet5.xml13
68
6940417071
91447273
92467460
93487576
111607778
1126279380
113648076
114668178
PK !
xl/sharedStrings.xmlIFS — Practice WorkbookXplorExcel.com · free Excel tutorials and practice filesLessonIFS Function in ExcelAll Excel lessonshttps://xplorexcel.com/excel-tutorial/What’s insideIllustrationA fully worked example. Click any cell to see the formula.Practice Sheet 1A register of readings. Two columns to band, one row each.Practice Sheet 2One account, separate decisions — and the band limits live in cells.Answer KeyEvery answer plus the exact formula that produces it.How to use it1Read the lesson first, then open the Illustration sheet.2Work through each Practice Sheet. Type formulas into the shaded cells.3Only then open the Answer Key. Compare your formula, not just your number.LicenceFree to use and share for personal study and classroom teaching. Please link back rather than re-hosting the file.CityRide Cabs — Trip Type worked exampleTripDistance (km)Trip TypeTR-901TR-902TR-903TR-904What is happening here• IFS checks each condition in order and stops at the first TRUE one. It replaces a stack of IF inside IF.• The parts come in pairs — condition, result, condition, result. Text results need double quotes; numbers must not have them.• Order decides the boundary. A value of exactly 15 is caught by the <= test for City Ride and never reaches the next condition.• Every band is written out here, so nothing is uncovered. If a value matched no condition at all, IFS would return #N/A.CityRide Cabs — Distance (km) registerSolve the following with the help of the IFS formula.Base Fare#QuestionYour AnswerTR-906Fill the Trip Type column with one IFS formula, then copy it down.→ fill in the tableFill the Base Fare column the same way — IFS returning a number, not a word.TR-909TR-905 sits exactly on 15 km, the top of City Ride. Report that one row.TR-905TR-908Type your formula in the shaded cells. Check yourself on the Answer Key sheet.TR-911TR-907TR-910TR-912CityRide Cabs — single account reviewMeasureValueThis month (Distance (km))Which band is this month in? Use IFS across all four bands.Last month (Distance (km))What is the base fare for this month?Band 1 upper limitWhich band was last month in?Band 2 upper limitRead the band limits from the cells below instead of typing the numbers.Band 3 upper limitTry every question before you read this. Compare the formula, not only the result.SheetFormula to useAnswer=IFS(C4<=5,"Short Hop",C4<=15,"City Ride",C4<=40,"Outstation",C4>=41,"Long Haul") ← bands in ascending orderShort Hop=IFS(C4<=5,60,C4<=15,140,C4<=40,380,C4>=41,900) ← no quotes around numbers=IFS(C7<=5,"Short Hop",C7<=15,"City Ride",C7<=40,"Outstation",C7>=41,"Long Haul") ← <= puts the boundary in the lower bandCity Ride=IFS(C4<=5,"Short Hop",C4<=15,"City Ride",C4<=40,"Outstation",C4>=41,"Long Haul")Outstation=IFS(C4<=5,60,C4<=15,140,C4<=40,380,C4>=41,900)=IFS(C5<=5,"Short Hop",C5<=15,"City Ride",C5<=40,"Outstation",C5>=41,"Long Haul")=IFS(C4<=C6,"Short Hop",C4<=C7,"City Ride",C4<=C8,"Outstation",C4>C8,"Long Haul") ← conditions can reference cells, not just numbersPK !q@= = [Content_Types].xmlPK ! - M xl/worksheets/sheet4.xmlPK ! c c V xl/worksheets/sheet5.xmlPK !
eb xl/sharedStrings.xmlPK |