{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["V+H LOOKUP","MATCH+INDEX","COLUMN+ROW","Nested IF","AND+OR","IFERROR","PMT"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"V+H LOOKUP","index":0,"n_rows":17,"n_cols":14,"rows_kept":17,"merged":[[4,13,4,14],[5,13,5,14],[7,7,7,10],[11,4,12,4],[11,5,12,5]]}
[]
[null,0,60,63,67,70,73,77,80,83,87,90,93,97]
[null,"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[]
[null,0,"F",{"$nulls":4},"ID1","ID2","ID3","ID4","ID5",null,"¬ 1st Row"]
[null,60,"D-",null,"ID1","Apple",null,"Apple","Microsoft","Samsung","Facebook","CUNY",null,"¬ 2nd Row"]
[null,63,"D",null,"ID2","Microsoft"]
[null,67,"D+",null,"ID3","Samsung",null,"Using LOOKUP functions, find what is the:"]
[null,70,"C-",null,"ID4","Facebook"]
[null,73,"C",null,"ID5","CUNY",{"$nulls":4},"VLOOKUP","HLOOKUP"]
[null,77,"C+",{"$nulls":4},"Company with ID1?",null,{"$f":"IFERROR(IF(K11=\"Apple\",\"✔ Correct!\",IF(COUNTBLANK(K11)<>1,\"❌ Wrong!\",\"→\")),\"❌ Wrong!\")","v":"→"},null,null,{"$f":"IFERROR(IF(L11=\"Apple\",\"✔ Correct!\",IF(COUNTBLANK(L11)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,80,"B-",null,"­\n1st Column","­\n2nd Column",null,"Company with ID4?",null,{"$f":"IFERROR(IF(K12=\"Facebook\",\"✔ Correct!\",IF(COUNTBLANK(K12)<>1,\"❌ Wrong!\",\"→\")),\"❌ Wrong!\")","v":"→"},null,null,{"$f":"IFERROR(IF(L12=\"Facebook\",\"✔ Correct!\",IF(COUNTBLANK(L12)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,83,"B",{"$nulls":4},"Letter grade for 87?",null,{"$f":"IFERROR(IF(K13=\"B+\",\"✔ Correct!\",IF(COUNTBLANK(K13)<>1,\"❌ Wrong!\",\"→\")),\"❌ Wrong!\")","v":"→"},null,null,{"$f":"IFERROR(IF(L13=\"B+\",\"✔ Correct!\",IF(COUNTBLANK(L13)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,87,"B+",{"$nulls":4},"Letter grade for 92?",null,{"$f":"IFERROR(IF(K14=\"A-\",\"✔ Correct!\",IF(COUNTBLANK(K14)<>1,\"❌ Wrong!\",\"→\")),\"❌ Wrong!\")","v":"→"},null,null,{"$f":"IFERROR(IF(L14=\"A-\",\"✔ Correct!\",IF(COUNTBLANK(L14)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,90,"A-"]
[null,93,"A"]
[null,97,"A+"]

{"sheet":"MATCH+INDEX","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"merged":[[1,1,1,5],[1,7,1,11],[3,8,3,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[9,7,9,11],[12,9,12,10],[13,9,13,10],[14,9,14,10]]}
[]
[null,"Revenue (in billions)",{"$nulls":5},"Using the MATCH function, find the position of:"]
[null,null,2019,2020,2021,2022]
[null,"Apple",{"v":2.5,"d":"$2.50"},{"v":2.8,"d":"$2.80"},{"v":3.1,"d":"$3.10"},{"v":3.5,"d":"$3.50"},null,"Samsung"," in the range B4:B11",{"$nulls":3},{"$f":"IFERROR(IF($L4=3,\"✔ Correct!\",IF(COUNTBLANK($L4)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"Microsoft",{"v":1.2,"d":"$1.20"},{"v":1.5,"d":"$1.50"},{"v":1.3,"d":"$1.30"},{"v":2.1,"d":"$2.10"},null,"Google"," in the range B4:B11",{"$nulls":3},{"$f":"IFERROR(IF($L5=6,\"✔ Correct!\",IF(COUNTBLANK($L5)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"Samsung",{"v":0.95,"d":"$0.95"},{"v":1.2,"d":"$1.20"},{"v":1.3,"d":"$1.30"},{"v":1.1,"d":"$1.10"},null,"Amazon"," in the range B4:B11 (tricky)",{"$nulls":3},{"$f":"IF(AND(COUNTBLANK($L6)<>1,ISERROR($L6)),\"✔ Correct!\",IF(COUNTBLANK($L6)<>1,\"❌ Wrong!\",\"←\"))","v":"←"}]
[null,"Facebook",{"v":6.5,"d":"$6.50"},{"v":4.3,"d":"$4.30"},{"v":5.5,"d":"$5.50"},{"v":5.5,"d":"$5.50"},null,2020," in the range C3:F3",{"$nulls":3},{"$f":"IFERROR(IF($L7=2,\"✔ Correct!\",IF(COUNTBLANK($L7)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"CUNY",{"v":0.0013,"d":"$0.0013"},{"v":1.5E-3,"d":"$0.0015"},{"v":0.0021,"d":"$0.0021"},{"v":2.3E-3,"d":"$0.0023"},null,2022," in the range C3:F3",{"$nulls":3},{"$f":"IFERROR(IF($L8=4,\"✔ Correct!\",IF(COUNTBLANK($L8)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"Google",{"v":65,"d":"$65.00"},{"v":69,"d":"$69.00"},{"v":71,"d":"$71.00"},{"v":256,"d":"$256.00"}]
[null,"Nokia",{"v":2.5,"d":"$2.50"},{"v":2.6,"d":"$2.60"},{"v":2.5,"d":"$2.50"},{"v":2.7,"d":"$2.70"},null,"Using the INDEX function, find the value at:"]
[null,"Paypal",{"v":1.5,"d":"$1.50"},{"v":2.6,"d":"$2.60"},{"v":2.9,"d":"$2.90"},{"v":2.1,"d":"$2.10"}]
[{"$nulls":7},"Row","Column"]
[{"$nulls":7},1,2," of the $$$ data",null,null,{"$f":"IFERROR(IF($L13=2.8,\"✔ Correct!\",IF(COUNTBLANK($L13)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[{"$nulls":7},5,4," of the $$$ data",null,null,{"$f":"IFERROR(IF($L14=0.0023,\"✔ Correct!\",IF(COUNTBLANK($L14)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[{"$nulls":7},8,3," of the $$$ data",null,null,{"$f":"IFERROR(IF($L15=2.9,\"✔ Correct!\",IF(COUNTBLANK($L15)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]

{"sheet":"COLUMN+ROW","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[1,1,1,7],[8,1,8,7]]}
[]
[null,"Using the COLUMN function, find the column number of:"]
[]
[null,"C15",null,{"$f":"IFERROR(IF(C4=3,\"✔ Correct!\",IF(COUNTBLANK(C4)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"},null,"R4",null,{"$f":"IFERROR(IF(G4=18,\"✔ Correct!\",IF(COUNTBLANK(G4)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"L23",null,{"$f":"IFERROR(IF(C5=12,\"✔ Correct!\",IF(COUNTBLANK(C5)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"},null,"O9",null,{"$f":"IFERROR(IF(G5=15,\"✔ Correct!\",IF(COUNTBLANK(G5)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"ND453",null,{"$f":"IFERROR(IF(C6=368,\"✔ Correct!\",IF(COUNTBLANK(C6)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"},null,"AAA1",null,{"$f":"IFERROR(IF(G6=703,\"✔ Correct!\",IF(COUNTBLANK(G6)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[]
[]
[null,"Using the ROW function, find the row number of:"]
[]
[null,"C15",null,{"$f":"IFERROR(IF(C11=15,\"✔ Correct!\",IF(COUNTBLANK(C11)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"},null,"R4",null,{"$f":"IFERROR(IF(G11=4,\"✔ Correct!\",IF(COUNTBLANK(G11)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"L23",null,{"$f":"IFERROR(IF(C12=23,\"✔ Correct!\",IF(COUNTBLANK(C12)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"},null,"O9",null,{"$f":"IFERROR(IF(G12=9,\"✔ Correct!\",IF(COUNTBLANK(G12)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]
[null,"ND453",null,{"$f":"IFERROR(IF(C13=453,\"✔ Correct!\",IF(COUNTBLANK(C13)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"},null,"AAA1",null,{"$f":"IFERROR(IF(G13=1,\"✔ Correct!\",IF(COUNTBLANK(G13)<>1,\"❌ Wrong!\",\"←\")),\"❌ Wrong!\")","v":"←"}]

{"sheet":"Nested IF","index":3,"n_rows":14,"n_cols":19,"rows_kept":14,"merged":[[1,1,1,16],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[6,1,6,6],[6,8,6,13],[7,1,7,6],[7,8,7,13],[9,1,9,8],[9,10,9,17],[10,1,10,8],[10,10,10,17],[12,1,12,10],[13,1,13,10]]}
[]
[null,"The following exercises let you figure out how nested IF functions work by gradually dividing such IF functions into simpler parts:"]
[]
[null,"Is 5>6 true or false?",{"$nulls":3},"Is -2<1 true or false?",{"$nulls":3},"Is 6<>8 true or false?",{"$nulls":3},"Is 3<=0 true or false?"]
[null,"=5>6",null,null,{"$f":"IFERROR(IF(B5=FALSE,\"✔\",IF(AND(COUNTBLANK(B5)<>1,B5<>\"=5>6\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=-2<1",null,null,{"$f":"IFERROR(IF(F5=TRUE,\"✔\",IF(AND(COUNTBLANK(F5)<>1,F5<>\"=-2<1\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=6<>8",null,null,{"$f":"IFERROR(IF(J5=TRUE,\"✔\",IF(AND(COUNTBLANK(J5)<>1,J5<>\"=6<>8\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=3<=0",null,null,{"$f":"IFERROR(IF(N5=FALSE,\"✔\",IF(AND(COUNTBLANK(N5)<>1,N5<>\"=3<=0\"),\"❌\",\"←\")),\"❌\")","v":"←"}]
[]
[null,"What will =IF(5>6,\"A\",\"B\") return?",{"$nulls":6},"What will =IF(-2<1,\"C\",\"D\") return?"]
[null,"=IF(5>6,\"A\",\"B\")",{"$nulls":5},{"$f":"IFERROR(IF(B8=\"B\",\"✔\",IF(AND(COUNTBLANK(B8)<>1,B8<>\"=IF(5>6,\"\"A\"\",\"\"B\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=IF(-2<1,\"C\",\"D\")",{"$nulls":5},{"$f":"IFERROR(IF(I8=\"C\",\"✔\",IF(AND(COUNTBLANK(I8)<>1,I8<>\"=IF(-2<1,\"\"C\"\",\"\"D\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"}]
[]
[null,"What will =IF(6<>8,IF(5>6,\"A\",\"B\"),\"E\") return?",{"$nulls":8},"What will =IF(3<=0,\"G\",IF(-2<1,\"C\",\"D\")) return?"]
[null,"=IF(6<>8,IF(5>6,\"A\",\"B\"),\"E\")",{"$nulls":7},{"$f":"IFERROR(IF(B11=\"B\",\"✔\",IF(AND(COUNTBLANK(B11)<>1,B11<>\"=IF(6<>8,IF(5>6,\"\"A\"\",\"\"B\"\"),\"\"E\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=IF(3<=0,\"G\",IF(-2<1,\"C\",\"D\"))",{"$nulls":7},{"$f":"IFERROR(IF(K11=\"C\",\"✔\",IF(AND(COUNTBLANK(K11)<>1,K11<>\"=IF(3<=0,\"\"G\"\",IF(-2<1,\"\"C\"\",\"\"D\"\"))\"),\"❌\",\"←\")),\"❌\")","v":"←"}]
[]
[null,"What will =IF(6<>8,IF(-2<1,\"C\",\"D\"),IF(5>6,\"A\",\"B\")) return?"]
[null,"=IF(6<>8,IF(-2<1,\"C\",\"D\"),IF(5>6,\"A\",\"B\"))",{"$nulls":9},{"$f":"IFERROR(IF(B14=\"C\",\"✔\",IF(AND(COUNTBLANK(B14)<>1,B14<>\"=IF(6<>8,IF(-2<1,\"\"C\"\",\"\"D\"\"),IF(5>6,\"\"A\"\",\"\"B\"\"))\"),\"❌\",\"←\")),\"❌\")","v":"←"}]

{"sheet":"AND+OR","index":4,"n_rows":14,"n_cols":18,"rows_kept":14,"merged":[[1,5,1,13],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[6,3,6,15],[8,1,8,4],[8,5,8,7],[8,10,8,13],[8,14,8,16],[9,1,9,4],[9,5,9,7],[9,10,9,13],[9,14,9,16],[10,1,10,4],[10,5,10,7],[10,10,10,13],[10,14,10,16],[11,1,11,4],[11,5,11,7],[11,10,11,13],[11,14,11,16],[12,1,12,4],[12,5,12,7],[12,10,12,13],[12,14,12,16],[13,1,13,4],[13,5,13,7],[13,10,13,13],[13,14,13,16]]}
[]
[{"$nulls":5},"Here are some results from the exercises on Nested IF functions:"]
[]
[null,"Is 5>6 true or false?",{"$nulls":3},"Is -2<1 true or false?",{"$nulls":3},"Is 6<>8 true or false?",{"$nulls":3},"Is 3<=0 true or false?"]
[null,{"$f":"'Nested IF'!B5","v":"=5>6"},null,null,{"$f":"IFERROR(IF(B5=FALSE,\"✔\",IF(AND(COUNTBLANK(B5)<>1,B5<>\"=5>6\"),\"❌\",\"\")),\"❌\")","v":""},{"$f":"'Nested IF'!F5","v":"=-2<1"},null,null,{"$f":"IFERROR(IF(F5=TRUE,\"✔\",IF(AND(COUNTBLANK(F5)<>1,F5<>\"=-2<1\"),\"❌\",\"\")),\"❌\")","v":""},{"$f":"'Nested IF'!J5","v":"=6<>8"},null,null,{"$f":"IFERROR(IF(J5=TRUE,\"✔\",IF(AND(COUNTBLANK(J5)<>1,J5<>\"=6<>8\"),\"❌\",\"\")),\"❌\")","v":""},{"$f":"'Nested IF'!N5","v":"=3<=0"},null,null,{"$f":"IFERROR(IF(N5=FALSE,\"✔\",IF(AND(COUNTBLANK(N5)<>1,N5<>\"=3<=0\"),\"❌\",\"\")),\"❌\")","v":""}]
[]
[{"$nulls":3},"Using the AND and OR functions, find if the following compound conditions are TRUE or FALSE:"]
[]
[null,"5>6 and -2<1",{"$nulls":6},{"$f":"IFERROR(IF(AND(F9=FALSE,COUNTBLANK(F9)<>1),\"✔\",IF(COUNTBLANK(F9)<>1,\"❌\",\"←\")),\"❌\")","v":"←"},null,"5>6 or -2<1",{"$nulls":6},{"$f":"IFERROR(IF(AND(O9=TRUE,COUNTBLANK(O9)<>1),\"✔\",IF(COUNTBLANK(O9)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[null,"6<>8 and -2<1",{"$nulls":6},{"$f":"IFERROR(IF(AND(F10=TRUE,COUNTBLANK(F10)<>1),\"✔\",IF(COUNTBLANK(F10)<>1,\"❌\",\"←\")),\"❌\")","v":"←"},null,"6<>8 or -2<1",{"$nulls":6},{"$f":"IFERROR(IF(AND(O10=TRUE,COUNTBLANK(O10)<>1),\"✔\",IF(COUNTBLANK(O10)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[null,"6<>8 and 3<=0",{"$nulls":6},{"$f":"IFERROR(IF(AND(F11=FALSE,COUNTBLANK(F11)<>1),\"✔\",IF(COUNTBLANK(F11)<>1,\"❌\",\"←\")),\"❌\")","v":"←"},null,"6<>8 or 3<=0",{"$nulls":6},{"$f":"IFERROR(IF(AND(O11=TRUE,COUNTBLANK(O11)<>1),\"✔\",IF(COUNTBLANK(O11)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[null,"5>6 and 3<=0",{"$nulls":6},{"$f":"IFERROR(IF(AND(F12=FALSE,COUNTBLANK(F12)<>1),\"✔\",IF(COUNTBLANK(F12)<>1,\"❌\",\"←\")),\"❌\")","v":"←"},null,"5>6 or 3<=0",{"$nulls":6},{"$f":"IFERROR(IF(AND(O12=FALSE,COUNTBLANK(O12)<>1),\"✔\",IF(COUNTBLANK(O12)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[null,"5>6 and -2<1 and 6<>8",{"$nulls":6},{"$f":"IFERROR(IF(AND(F13=FALSE,COUNTBLANK(F13)<>1),\"✔\",IF(COUNTBLANK(F13)<>1,\"❌\",\"←\")),\"❌\")","v":"←"},null,"5>6 or -2<1 or 6<>8",{"$nulls":6},{"$f":"IFERROR(IF(AND(O13=TRUE,COUNTBLANK(O13)<>1),\"✔\",IF(COUNTBLANK(O13)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[null,"-2<1 and 6<>8 and 3<=0",{"$nulls":6},{"$f":"IFERROR(IF(AND(F14=FALSE,COUNTBLANK(F14)<>1),\"✔\",IF(COUNTBLANK(F14)<>1,\"❌\",\"←\")),\"❌\")","v":"←"},null,"-2<1 or 6<>8 or 3<=0",{"$nulls":6},{"$f":"IFERROR(IF(AND(O14=TRUE,COUNTBLANK(O14)<>1),\"✔\",IF(COUNTBLANK(O14)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]

{"sheet":"IFERROR","index":5,"n_rows":10,"n_cols":17,"rows_kept":10,"merged":[[1,1,3,16],[5,1,5,3],[5,5,5,7],[5,9,5,11],[5,13,5,15],[6,1,6,3],[6,5,6,7],[6,9,6,11],[6,13,6,15],[8,1,8,3],[8,5,8,7],[8,9,8,11],[8,13,8,15],[9,1,9,3],[9,5,9,7],[9,9,9,11],[9,13,9,15]]}
[]
[null,"The function IFERROR takes 2 values: the value that it checks for an error, and the value that should be returned if the 1st value contains an error. Lets call them value A and value B. Specifically, if value A has an error, then IFERROR returns value B. Otherwise, if there is no error in value A, then IFERROR returns value A itself."]
[]
[]
[]
[null,"Does 10/0 have an error?",{"$nulls":3},"Does 2/5 have an error?",{"$nulls":3},"Does A1 have an error?",{"$nulls":3},"Does A0 have an error?"]
[null,"=10/0",null,null,{"$f":"IFERROR(IF(AND(COUNTBLANK(B7)<>1,B7<>\"=10/0\"),\"❌\",\"←\"),\"✔\")","v":"←"},"=2/5",null,null,{"$f":"IFERROR(IF(F7=0.4,\"✔\",IF(AND(COUNTBLANK(F7)<>1,F7<>\"=2/5\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=A1",null,null,{"$f":"IFERROR(IF(J7=0,\"✔\",IF(AND(COUNTBLANK(J7)<>1,J7<>\"=A1\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=A0",null,null,{"$f":"IFERROR(IF(AND(COUNTBLANK(N7)<>1,N7<>\"=A0\"),\"❌\",\"←\"),\"✔\")","v":"←"}]
[]
[null,"Now, lets use IFERROR:",{"$nulls":3},"Now, lets use IFERROR:",{"$nulls":3},"Now, lets use IFERROR:",{"$nulls":3},"Now, lets use IFERROR:"]
[null,"=IFERROR(10/0,\"Error!\")",null,null,{"$f":"IFERROR(IF(B10=\"Error!\",\"✔\",IF(AND(COUNTBLANK(B10)<>1,B10<>\"=IFERROR(10/0,\"\"Error!\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=IFERROR(2/5,\"Error!\")",null,null,{"$f":"IFERROR(IF(F10=0.4,\"✔\",IF(AND(COUNTBLANK(F10)<>1,F10<>\"=IFERROR(2/5,\"\"Error!\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=IFERROR(A1,\"Error!\")",null,null,{"$f":"IFERROR(IF(J10=0,\"✔\",IF(AND(COUNTBLANK(J10)<>1,J10<>\"=IFERROR(A1,\"\"Error!\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"},"=IFERROR(A0,\"Error!\")",null,null,{"$f":"IFERROR(IF(N10=\"Error!\",\"✔\",IF(AND(COUNTBLANK(N10)<>1,N10<>\"=IFERROR(A0,\"\"Error!\"\")\"),\"❌\",\"←\")),\"❌\")","v":"←"}]

{"sheet":"PMT","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[1,1,1,12],[3,1,3,3],[4,1,8,3],[10,1,10,3],[11,1,14,3]]}
[]
[null,"Using the PMT (Payment) Excel function, find the positive value of the monthly loan payment that you need to make to pay the loan out:"]
[]
[null,"Reminder:",{"$nulls":3},"Rate","Number of Periods (Nper)","Present Value (PV)","Payment (PMT)"]
[null,"Don't forget to divide the Rate by 12, since the rate is annual, but the payments are made every month.",{"$nulls":3},{"v":0.03,"d":"3.0%"},24,{"v":10000,"d":"$10,000.00"},null,{"$f":"IFERROR(IF($I5=(PMT(F5/12,G5,-H5)),\"✔\",IF(COUNTBLANK($I5)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[{"$nulls":5},{"v":0.05,"d":"5.0%"},180,{"v":450000,"d":"$450,000.00"},null,{"$f":"IFERROR(IF($I6=(PMT(F6/12,G6,-H6)),\"✔\",IF(COUNTBLANK($I6)<>1,\"❌\",\"←\")),\"❌\")","v":"←"}]
[{"$nulls":5},{"v":0.045,"d":"4.5%"},360,{"v":600000,"d":"$600,000.00"},null,"←"]
[{"$nulls":5},{"v":0.06,"d":"6.0%"},12,{"v":5000,"d":"$5,000.00"},null,"←"]
[{"$nulls":5},{"v":0.03,"d":"3.0%"},36,{"v":20000,"d":"$20,000.00"},null,"←"]
[{"$nulls":5},{"v":0.025,"d":"2.5%"},60,{"v":15000,"d":"$15,000.00"},null,"←"]
[null,"Note:",{"$nulls":3},{"v":0.06,"d":"6.0%"},180,{"v":200000,"d":"$200,000.00"},null,"←"]
[null,"To find the positive value of the payment, negate the Present Value (PV).",{"$nulls":3},{"v":0.05,"d":"5.0%"},480,{"v":100000,"d":"$100,000.00"},null,"←"]