{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Cover","NF(1)","NF(1an)","NF(2)","NF(2an)","NF(3)","NF(3an)","NF(4)","NF(4an)","NF(5)","NF(5an)","ROUND(1)","ROUND(1an)","ROUND(2)","ROUND(2an)","HW ==>>","HW(1)","HW(1an)","HW(2)","HW(2an)"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel Basics 9: Number Formatting as Façade & the ROUND Function"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office 2016 Video #21"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Number Formatting displays number a certain way without changing it!"]
[]
[null,null,"Formula can't \"see\" Number Formatting"]

{"sheet":"NF(1)","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["What does Number Formatting do?",null,null,null,"Employee","Sales"]
[null,null,null,null,"Abdi",35060.705600000001]
[null,null,null,null,"Gigi",25341.700700000001]
[null,null,null,null,"Pham",24428.465899999999]
[null,null,null,null,"Tyrone",33965.603900000002]
[null,null,null,null,"Sioux",29549.5599]
[null,null,null,null,"Miki",25175.6986]
[null,null,null,null,"Naoya",47516.873200000002]
[null,null,null,null,null,null,null,null,null,"Façade:"]

{"sheet":"NF(1an)","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["What does Number Formatting do?",null,null,null,"Employee","Sales"]
[null,null,null,null,"Abdi",35060.705600000001]
[null,null,null,null,"Gigi",25341.700700000001]
[null,null,null,null,"Pham",24428.465899999999]
[null,null,null,null,"Tyrone",33965.603900000002]
[null,null,null,null,"Sioux",29549.5599]
[null,null,null,null,"Miki",25175.6986]
[null,null,null,null,"Naoya",47516.873200000002]

{"sheet":"NF(2)","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Price","Quantity","Total",null,"Formula in cell:"]
[99.5,2,null,null,{"$f":"IF(_xlfn.ISFORMULA(C2),\"Formula in cell \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" is:\"&CHAR(10)&_xlfn.FORMULATEXT(C2)&\" (\"&A1&\"*\"&B1&\")\",\"\")","v":""}]
[]
[]
[]
["Formulas do not “see” Number Formatting."]
["1) Formulas make calculations on the underlying number that sits in the cell."]
["2) Formulas do NOT make calculations on the Number Formatting that you see on the surface of the cell."]

{"sheet":"NF(2an)","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Price","Quantity","Total",null,"Formula in cell:"]
[99.5,2,{"$f":"A2*B2","v":199},null,{"$f":"\"Formula in cell \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" is:\"&CHAR(10)&_xlfn.FORMULATEXT(C2)&\" (\"&A1&\"*\"&B1&\")\"","v":"Formula in cell C2 is:\n=A2*B2 (Price*Quantity)"}]
[]
[]
[]
["Formulas do not “see” Number Formatting."]
["1) Formulas make calculations on the underlying number that sits in the cell."]
["2) Formulas do NOT make calculations on the Number Formatting that you see on the surface of the cell."]

{"sheet":"NF(3)","index":5,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Number Formatting can save us a lot of time with data entry!!"]
[]
[]
[null,null,null,null,null,"Sales",null,"Sales"]

{"sheet":"NF(3an)","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Number Formatting can save us a lot of time with data entry!!"]
[]
[]
[null,null,null,null,null,"Sales",null,"Sales"]
[null,null,null,null,null,45,null,45]
[null,null,null,null,null,65.2,null,65.2]
[null,null,null,null,null,78.989999999999995,null,78.989999999999995]
[null,null,null,null,null,100,null,100]
[null,null,null,null,null,101,null,101]
[null,null,null,null,null,95.2,null,98.2]
[null,null,null,null,null,20,null,20]

{"sheet":"NF(4)","index":7,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"General",null,"Currency",null,"Accounting",null,null,"General Number Formatting:"]
[null,"Sales",null,"Sales",null,"Sales",null,null,"General Number Formatting = What you see is what is in the cell."]
[null,45,null,{"$f":"B4","v":45},null,{"$f":"D4","v":45},null,null,"General Number Formatting ERASES all previously applied Number Formatting."]
[null,0,null,0,null,0,null,null,"Accounting Number Format:"]
[null,78.989999999999995,null,78.989999999999995,null,78.989999999999995,null,null,"Fixed dollar sign (left edge of cell)."]
[null,100,null,100,null,100,null,null,"Negatives are in parenthesis."]
[null,-101,null,-101,null,-101,null,null,"Zeros are dashes."]
[null,98.2,null,98.2,null,98.2,null,null,"Decimals always line up."]
[null,20,null,20,null,20,null,null,"Currency:"]
[null,null,null,null,null,null,null,null,"Floating dollar sign."]
[null,null,null,null,null,null,null,null,"You choose how to show negatives."]
[null,null,null,null,null,null,null,null,"Zeros are zeros."]
[null,null,null,null,null,null,null,null,"Decimals usually line up."]

{"sheet":"NF(4an)","index":8,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"General",null,"Currency",null,"Accounting",null,null,"General Number Formatting:"]
[null,"Sales",null,"Sales",null,"Sales",null,null,"General Number Formatting = What you see is what is in the cell."]
[null,45,null,{"$f":"B4","v":45},null,{"$f":"D4","v":45},null,null,"General Number Formatting ERASES all previously applied Number Formatting."]
[null,0,null,0,null,0,null,null,"Accounting Number Format:"]
[null,78.989999999999995,null,78.989999999999995,null,78.989999999999995,null,null,"Fixed dollar sign (left edge of cell)."]
[null,100,null,100,null,100,null,null,"Negatives are in parenthesis."]
[null,-101,null,-101,null,-101,null,null,"Zeros are dashes."]
[null,98.2,null,98.2,null,98.2,null,null,"Decimals always line up."]
[null,20,null,20,null,20,null,null,"Currency:"]
[null,null,null,null,null,null,null,null,"Floating dollar sign."]
[null,null,null,null,null,null,null,null,"You choose how to show negatives."]
[null,null,null,null,null,null,null,null,"Zeros are zeros."]
[null,null,null,null,null,null,null,null,"Decimals usually line up."]

{"sheet":"NF(5)","index":9,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Tax Rate",9.5000000000000001E-2,null,{"$f":"B1*100&\" pennies for every $1.\"","v":"9.5 pennies for every $1."},null,null,"Don't get trick by Percentage Number Formatting:"]
["Tax Rate",9.5000000000000001E-2,null,"9.5 pennies for every $1."]
[null,null,null,null,null,null,"Tax Rate",1.4500000000000001E-2]
[null,null,null,null,null,null,"Amount",1,null,"1% of $1 is 1 penny, right?"]
["Tax Rate",0.03,null,{"$f":"B5*100&\" pennies for every $1.\"","v":"3 pennies for every $1."},null,null,"Tax Amount",null,null,"Formulas do NOT \"see\" Number Formatting."]
["Tax Rate",0.03,null,"3 pennies for every $1.",null,null,null,null,null,"Formula Calculate on underlying Number"]
[]
["Percentage Number Formatting"]
["For the number 0.03,"]
["Percentage Number Formatting displays the number with:"]
[]
[null,"1) The decimal slid two positions to the right"]
[null,"and"]
[null,"2) A percentage sign."]
[]
[null,"0.03 displays as 3.00%"]

{"sheet":"NF(5an)","index":10,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Tax Rate",9.5000000000000001E-2,null,{"$f":"B1*100&\" pennies for every $1.\"","v":"9.5 pennies for every $1."},null,null,"Don't get trick by Percentage Number Formatting:"]
["Tax Rate",9.5000000000000001E-2,null,"9.5 pennies for every $1."]
[null,{"$f":"9.5/100","v":9.5000000000000001E-2},null,null,null,null,"Tax Rate",1.4500000000000001E-2]
[null,null,null,null,null,null,"Amount",1,null,"1% of $1 is 1 penny, right?"]
["Tax Rate",0.03,null,{"$f":"B5*100&\" pennies for every $1.\"","v":"3 pennies for every $1."},null,null,"Tax Amount",{"$f":"H4*H3","v":1.4500000000000001E-2},null,"Formulas do NOT \"see\" Number Formatting."]
["Tax Rate",0.03,null,"3 pennies for every $1.",null,null,null,1.4500000000000001E-2,null,"Formula Calculate on underlying Number"]
[]
["Percentage Number Formatting"]
["For the number 0.03,"]
["Percentage Number Formatting displays the number with:"]
[]
[null,"1) The decimal slid two positions to the right"]
[null,"and"]
[null,"2) A percentage sign."]
[]
[null,"0.03 displays as 3.00%"]

{"sheet":"ROUND(1)","index":11,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How to round by hand?"]
[null,"1) Pick position you want to round to"]
[null,"2) look at digit to right:"]
[null,"5 or bigger ==>>  add one to position you are rounding to and remove unwanted digits"]
[null,"4 or less     ==>>  remove unwanted digits"]
[]
[null,52.727624999999996,"52.727625","52.727625","52.7(2+1)7625",52.73]
[null,52.724584,"52.724584","52.724584","52.7(2+0)4584",52.72]
[]
[null,"We can use the ROUND function to remove unwanted decimals"]
[]
[null,"Payroll:",null,null,"No Number Format","Currency Number Format does NOT Remove Decimals","ROUND Removes Decimals after Penny Position"]
[null,"Employee","Tax Rate","Gross Pay","Tax Deduction",null,"Tax Deduction"]
[null,"Lillian  Holt",7.6499999999999999E-2,689.25]
[null,null,null,null,{"$f":"IF(_xlfn.ISFORMULA(E15),\"Formula in above cell is: \"&_xlfn.FORMULATEXT(E15),\"\")","v":""},"",""]
[]
[null,null,null,null,"Rules for ROUND Function second argument:"]
[null,null,null,null,"Round to penny (hundredths position) use 2"]
[null,null,null,null,"Round to dollar (ones position) use 0"]
[null,null,null,null,"Round to thousands (thousands position) use -3"]

{"sheet":"ROUND(1an)","index":12,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How to round by hand?"]
[null,"1) Pick position you want to round to"]
[null,"2) look at digit to right:"]
[null,"5 or bigger ==>>  add one to position you are rounding to and remove unwanted digits"]
[null,"4 or less     ==>>  remove unwanted digits"]
[]
[null,52.727624999999996,"52.727625","52.727625","52.7(2+1)7625",52.73]
[null,52.724584,"52.724584","52.724584","52.7(2+0)4584",52.72]
[]
[null,"We can use the ROUND function to remove unwanted decimals"]
[]
[null,"Payroll:",null,null,"No Number Format","Currency Number Format does NOT Remove Decimals","ROUND Removes Decimals after Penny Position"]
[null,"Employee","Tax Rate","Gross Pay","Tax Deduction",null,"Tax Deduction"]
[null,"Lillian  Holt",7.6499999999999999E-2,689.25,{"$f":"D15*C15","v":52.727624999999996},{"$f":"D15*C15","v":52.727624999999996},{"$f":"ROUND(D15*C15,2)","v":52.73}]
[null,null,null,null,{"$f":"IF(_xlfn.ISFORMULA(E15),\"Formula in above cell is: \"&_xlfn.FORMULATEXT(E15),\"\")","v":"Formula in above cell is: =D15*C15"},"Formula in above cell is: =D15*C15","Formula in above cell is: =ROUND(D15*C15,2)"]
[]
[null,null,null,null,"Rules for ROUND Function second argument:"]
[null,null,null,null,"Round to penny (hundredths position) use 2"]
[null,null,null,null,"Round to dollar (ones position) use 0"]
[null,null,null,null,"Round to thousands (thousands position) use -3"]

{"sheet":"ROUND(2)","index":13,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["When you MUST use ROUND:",null,null,"When not to use ROUND:"]
["1) You are required to round, like with Money.",null,null,"When you are just looking at number, then you can use Number Formatting"]
["2) You have extraneous decimals, like past the penny position."]
["3) You will use formula result in a subsequent formula."]
[]
["Rules for ROUND:",null,null,"Examples where you often have to round your numbers:"]
["Round to penny (hundredths position) use 2",null,null,"Payroll"]
["Round to dollar (ones position) use 0",null,null,"Invoices"]
["Round to thousands (thousands position) use -3",null,null,"Income Taxes"]
[]
[]
["Payroll:",null,"No ROUND","ROUND"]
["Employee","Gross Pay ($)","Tax Deduction","Tax Deduction",null,"Type What you see:"]
["Lillian  Holt",689.25]
["Jasmine  Phelps",765.71]
["Sadie  Hudson",687.43]
[null,"Total"]
[]
["Tax Rate",7.6499999999999999E-2]
[]
[]
["Invoicing:"]
["Invoice Number",1025]
["Item","Price ($)","Units","Total",null,null,null,"Total"]
["1'' screws",5.1299999999999998E-2,31,null,null,null,null,{"$f":"C25*B25","v":1.5903}]
["2'' screws",7.7499999999999999E-2,21,null,null,null,null,{"$f":"C26*B26","v":1.6274999999999999}]
["6\" lock pads",1.0569999999999999,11,null,null,null,null,{"$f":"C27*B27","v":11.626999999999999}]
[null,null,"Subtotal",{"$f":"SUM(D25:D27)","v":0},null,"Tax Rate",null,{"$f":"SUM(H25:H27)","v":14.844799999999999}]
[null,null,"Tax",null,null,9.7500000000000003E-2]
[null,null,"Total",{"$f":"SUM(D28:D29)","v":0}]
["Thanks for your Order!"]
[]
["**Payroll Taxes and Invoices often times have to round to the penny."]
["**Sometimes for INCOME TAXES you have to round to the dollar."]
[]
["Income Tax:"]
["Taxable Amount","Tax\nrounded to dollar",null,"Tax Rate"]
[2345.98,null,null,0.155]
[345.49]
[235.8]
[2541.12]

{"sheet":"ROUND(2an)","index":14,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["When you MUST use ROUND:",null,null,"When not to use ROUND:"]
["1) You are required to round, like with Money.",null,null,"When you are just looking at number, then you can use Number Formatting"]
["2) You have extraneous decimals, like past the penny position."]
["3) You will use formula result in a subsequent formula."]
[]
["Rules for ROUND:",null,null,"Examples where you often have to round your numbers:"]
["Round to penny (hundredths position) use 2",null,null,"Payroll"]
["Round to dollar (ones position) use 0",null,null,"Invoices"]
["Round to thousands (thousands position) use -3",null,null,"Income Taxes"]
[]
[]
["Payroll:",null,"No ROUND","ROUND"]
["Employee","Gross Pay","Tax Deduction","Tax Deduction",null,"Type What you see:"]
["Lillian  Holt",689.25,{"$f":"B14*$B$19","v":52.727624999999996},{"$f":"ROUND(B14*$B$19,2)","v":52.73},null,52.73]
["Jasmine  Phelps",765.71,{"$f":"B15*$B$19","v":58.576815000000003},{"$f":"ROUND(B15*$B$19,2)","v":58.58},null,58.58]
["Sadie  Hudson",687.43,52.588394999999998,52.59,null,52.59]
[null,"Total",{"$f":"SUM(C14:C16)","v":163.89283499999999},{"$f":"SUM(D14:D16)","v":163.9},null,{"$f":"SUM(F14:F16)","v":163.9}]
[]
["Tax Rate",7.6499999999999999E-2]
[]
[]
["Invoicing:"]
["Invoice Number",1025]
["Item","Price","Units","Total",null,null,null,"Total"]
["1'' screws",5.1299999999999998E-2,31,{"$f":"ROUND(C25*B25,2)","v":1.59},null,null,null,{"$f":"C25*B25","v":1.5903}]
["2'' screws",7.7499999999999999E-2,21,{"$f":"ROUND(C26*B26,2)","v":1.63},null,null,null,{"$f":"C26*B26","v":1.6274999999999999}]
["6\" lock pads",1.0569999999999999,11,11.63,null,null,null,{"$f":"C27*B27","v":11.626999999999999}]
[null,null,"Subtotal",{"$f":"SUM(D25:D27)","v":14.850000000000001},null,"Tax Rate",null,{"$f":"SUM(H25:H27)","v":14.844799999999999}]
[null,null,"Tax",{"$f":"ROUND(D28*F29,2)","v":1.45},null,9.7500000000000003E-2]
[null,null,"Total",{"$f":"SUM(D28:D29)","v":16.3}]
["Thanks for your Order!"]
[]
["**Payroll Taxes and Invoices often times have to round to the penny."]
["**Sometimes for INCOME TAXES you have to round to the dollar."]
[]
["Income Tax:"]
["Taxable Amount","Tax\nrounded to dollar",null,"Tax Rate"]
[2345.98,{"$f":"ROUND(A38*$D$38,0)","v":364},null,0.155]
[345.49,{"$f":"ROUND(A39*$D$38,0)","v":54}]
[235.8,37]
[2541.12,394]

{"sheet":"HW ==>>","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"HW(1)","index":16,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Calculate the Tax Deduction for each employee and then add to get the Total Tax Deduction"]
[]
["Employee","Gross Pay","Tax Deduction",null,"Tax Rate"]
["Sioux",5262.26,null,null,1.4749999999999999E-2]
["Lindee",5531.85]
["Billy",5867.76]
["Mo",4976.26]
["Abdi",5938.27]
["Lindee",4290.34]
["Chin",5000.3999999999996]
["Danny",4780.87]
["Osborn",4536.95]
["Phil",4070.94]
["Ann",5018.7299999999996]
["Sioux",4322.54]
["ShelaDawn",4969.74]
[null,"Total"]

{"sheet":"HW(1an)","index":17,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Calculate the Tax Deduction for each employee and then add to get the Total Tax Deduction"]
[]
["Employee","Gross Pay","Tax Deduction",null,"Tax Rate",null,"Incorrect"]
["Sioux",5262.26,{"$f":"ROUND(B4*$E$4,2)","v":77.62},null,1.4749999999999999E-2,null,{"$f":"B4*$E$4","v":77.618335000000002}]
["Lindee",5531.85,81.59,null,null,null,81.594787499999995]
["Billy",5867.76,86.55,null,null,null,86.549459999999996]
["Mo",4976.26,73.400000000000006,null,null,null,73.399834999999996]
["Abdi",5938.27,87.59,null,null,null,87.589482500000003]
["Lindee",4290.34,63.28,null,null,null,63.282514999999997]
["Chin",5000.3999999999996,73.760000000000005,null,null,null,73.755899999999997]
["Danny",4780.87,70.52,null,null,null,70.517832499999997]
["Osborn",4536.95,66.92,null,null,null,66.920012499999999]
["Phil",4070.94,60.05,null,null,null,60.046364999999994]
["Ann",5018.7299999999996,74.03,null,null,null,74.026267499999989]
["Sioux",4322.54,63.76,null,null,null,63.757464999999996]
["ShelaDawn",4969.74,73.3,null,null,null,73.303664999999995]
[null,"Total",{"$f":"SUM(C4:C16)","v":952.36999999999978},null,null,null,{"$f":"SUM(G4:G16)","v":952.36192249999999}]

{"sheet":"HW(2)","index":18,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["What is misleading about the below spreadhseet?"]
[]
["Employee","Sales","Tax Deduction",null,"Tax Rate"]
["Sioux",300,{"$f":"B4*$E$4","v":31.424999999999997},null,0.10475]
["Lindee",300,31.424999999999997]
["Billy",300,31.424999999999997]
["Mo",300,31.424999999999997]
["Abdi",300,31.424999999999997]
["Lindee",400,41.9]
["Chin",300,31.424999999999997]
["Danny",400,41.9]
["Osborn",300,31.424999999999997]
["Phil",400,41.9]
["Ann",400,41.9]
["Sioux",200,20.95]
["ShelaDawn",400,41.9]

{"sheet":"HW(2an)","index":19,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["What is misleading about the below spreadhseet?"]
[]
["Employee","Sales","Tax Deduction",null,"Tax Rate"]
["Sioux",300,{"$f":"B4*$E$4","v":31.424999999999997},null,0.10475]
["Lindee",300,31.424999999999997]
["Billy",300,31.424999999999997]
["Mo",300,31.424999999999997,null,"Answer: The Tax Rate has had the decimals decreased. I"]
["Abdi",300,31.424999999999997,null,"am not sure if the person who created this thought the tax"]
["Lindee",400,41.9,null,"rate is supposed to be 10% or not, or if the formula result is"]
["Chin",300,31.424999999999997,null,"correct. I do know that the formula can NOT \"see\" Number"]
["Danny",400,41.9,null,"Formatting."]
["Osborn",300,31.424999999999997]
["Phil",400,41.9]
["Ann",400,41.9]
["Sioux",200,20.95]
["ShelaDawn",400,41.9]