{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Notes","index":0,"n_rows":103,"n_cols":10,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Supplemental Assignment Notes"]
["IF Function",null,"https://www.youtube.com/watch?v=KkTaQ5OjAGc"]
[null,null,"Use this function when the result for a cell is one of two"]
[null,null,"possible values:"]
[null,null,"=IF(condition,cell value if condition is true,cell value if condition is false)"]
[null,null,"Examples:"]
[null,null,1,{"$f":"IF(C7<>1,\"Error!\",SUM(C7:C10))","v":10},{"$f":"getformula(D7)","v":"<--  =IF(C7<>1,\"Error!\",SUM(C7:C10))"}]
[null,null,2,{"$f":"IF(AND(C7=1,C8=2),\"Both Correct!\",\"Both NOT correct\")","v":"Both Correct!"},null,{"$f":"getformula(D8)","v":"<--  =IF(AND(C7=1,C8=2),\"Both Correct!\",\"Both NOT correct\")"}]
[null,null,3,{"$f":"IF(OR(C7=1,C8=2),\"1 or 2 Correct!\",\"Both NOT correct\")","v":"1 or 2 Correct!"},null,{"$f":"getformula(D9)","v":"<--  =IF(OR(C7=1,C8=2),\"1 or 2 Correct!\",\"Both NOT correct\")"}]
[null,null,4,{"$f":"IF(C10^2/(1+C10/100)>=1,ROUND(1+C10/100,2),999)","v":1.04},{"$f":"getformula(D10)","v":"<--  =IF(C10^2/(1+C10/100)>=1,ROUND(1+C10/100,2),999)"}]
[null,null,"Note that each of the 3 arguments in the IF function may be elaborate"]
[null,null,"\"formulas\" with other functions and cell references. It is not unusual to see an IF"]
[null,null,"function as an argument to an IF function (nested IF)."]
["AND Function"]
[null,"Checks if ALL arguments are TRUE."]
[null,"Returns TRUE if they are and FALSE if not."]
["OR Function"]
[null,"Checks if ANY arguments are TRUE."]
[null,"Returns TRUE if at least one is TRUE and FALSE if not."]
[]
[null,"Order (low to high) in IF test:"]
[null,"empty cell -->"]
[null,"0 -->",0,{"$f":"C23=C22","v":true},{"$f":"getformula(D23)","v":"<--  =C23=C22"},"<-- Empty cell and zero considered Equal!"]
[null,"1 -->",1,{"$f":"C24>C23","v":true},{"$f":"getformula(D24)","v":"<--  =C24>C23"}]
[null,"2 -->",2,{"$f":"C25>C24","v":true},"<--  =C25>C24"]
[null,"3 -->",3,true,"<--  =C26>C25"]
[null,"99 -->",99,true,"<--  =C27>C26"]
[null,"2 double \" -->",{"$f":"\"\"","v":""},true,"<--  =C28>C27"]
[null,"space -->"," ",true,"<--  =C29>C28"]
[null,"! -->","!",true,"<--  =C30>C29"]
[null,"# -->","#",true,"<--  =C31>C30"]
[null,"@ -->","@",true,"<--  =C32>C31"]
[null,"a -->","a",true,"<--  =C33>C32"]
[null,"z -->","z",true,"<--  =C34>C33"]
["Don’t use a math operator (+-*/^) on a text cell!",null,null,null,null,null,"But this works:"]
[null,"Text",5,{"$f":"B36*C36","v":{"$error":"#VALUE!"}},{"$f":"getformula(D36)","v":"<--  =B36*C36"},null,"Number as TEXT"]
[null,"Over",4,{"$f":"B37+1","v":{"$error":"#VALUE!"}},{"$f":"getformula(D37)","v":"<--  =B37+1"},null,{"$f":"\"222\"","v":"222"},4,{"$f":"G37+H37","v":226},{"$f":"getformula(I37)","v":"<--  =G37+H37"}]
[null,"Under",3,{"$f":"B38/C38","v":{"$error":"#VALUE!"}},"<--  =B38/C38",null,{"$f":"\"333\"","v":"333"},3,{"$f":"G38/H38","v":111},"<--  =G38/H38"]
["Use apersand (&) to join (concatenate) pieces of text!"]
[null,"day",2,{"$f":"B40&C40","v":"day2"},{"$f":"getformula(D40)","v":"<--  =B40&C40"}]
[null,"Jim","Bob",{"$f":"B41&C41","v":"JimBob"},{"$f":"getformula(D41)","v":"<--  =B41&C41"}]
[null,"Jim","Bob",{"$f":"B42&\" \"&C42","v":"Jim Bob"},{"$f":"getformula(D42)","v":"<--  =B42&\" \"&C42"}]
["Rounding Functions",null,null,null,null,null,"FIXED Function: Converts value to text"]
[null,123.456,{"$f":"ROUND(B44,0)","v":123},{"$f":"getformula(C44)","v":"<--  =ROUND(B44,0)"},null,null,{"$f":"FIXED(C44,1)","v":"123.0"},{"$f":"getformula(G44)","v":"<--  =FIXED(C44,1)"}]
[null,123.456,{"$f":"ROUND(B45,1)","v":123.5},{"$f":"getformula(C45)","v":"<--  =ROUND(B45,1)"},null,null,{"$f":"FIXED(C45*100,0)","v":"12,350"},"<--  =FIXED(C45*100,0)"]
[null,123.456,{"$f":"ROUND(B46,-2)","v":100},"<--  =ROUND(B46,-2)",null,null,{"$f":"\"Number = \"&FIXED(C46*100,1)","v":"Number = 10,000.0"},"<--  =\"Number = \"&FIXED(C46*100,1)"]
[null,123.456,{"$f":"ROUNDUP(B47,1)","v":123.5},"<--  =ROUNDUP(B47,1)",null,null,{"$f":"\"X = \"&FIXED(C47*100,2)&\"%\"","v":"X = 12,350.00%"},"<--  =\"X = \"&FIXED(C47*100,2)&\"%\""]
[null,123.456,{"$f":"ROUNDUP(B48,2)","v":123.46000000000001},"<--  =ROUNDUP(B48,2)",null,null,{"$f":"\"Max = \"&FIXED(SUM(C44:C49)-33,2)&\" Units\"","v":"Max = 683.91 Units"},"<--  =\"Max = \"&FIXED(SUM(C44:C49)-33,2)&\" Units\""]
[null,123.456,{"$f":"ROUNDDOWN(B49,2)","v":123.45},"<--  =ROUNDDOWN(B49,2)"]
[null,123.456,{"$f":"ROUNDDOWN(B50,-2)","v":100},"<--  =ROUNDDOWN(B50,-2)"]
[null,{"$f":"SUM(B44:B50)","v":864.19200000000001},{"$f":"SUM(C44:C50)","v":816.91000000000008},{"$f":"\"<--Totals \"&IF(C51<>B51,\"Differ!\",\"Same!\")","v":"<--Totals Differ!"},null,{"$f":"getformula(D51)","v":"<--  =\"<--Totals \"&IF(C51<>B51,\"Differ!\",\"Same!\")"}]
[]
["Data Validation"]
[null,"Use Data/Data Validation/Data Validation to constrain input cell values",null,null,null,null,null,null,null,"Data Validation List:"]
[null,null,"Settings: Specify what may be entered into this cell",null,null,null,null,null,null,"Robert"]
[null,null,"Input Message: Show this message when cell is selected",null,null,null,null,null,null,"Elaine"]
[null,null,"Error Alert: Show this message when value entered is incorrect",null,null,null,null,null,null,"Susan"]
[null,{"$f":"\"See Cell \"&CELL(\"address\",I54)&\" Above\"","v":"See Cell $I$54 Above"},null,null,{"$f":"getformula(B58)","v":"<--  =\"See Cell \"&CELL(\"address\",I54)&\" Above\""},null,null,null,null,"Thomas"]
["Conditional Formatting: Formula Rule",null,null,null,null,null,null,null,null,"Amelia"]
[null,"Use this command (Home/Conditional Formatting) to set an"]
[null,"alternate format based on conditions you specify."]
[null,1,"Start by selecting the cell or cells for which will display one"]
[null,null,"of two formats based on a formula that is true or false."]
[null,2,"Select: Home/Conditional Formatting/New Rule/Use a formula…"]
[null,3,"Enter the appropriate formula as a condition"]
[null,4,"Specify the new format to be applied if the formula result is true"]
[null,"Examples:"]
[null,1,12345,{"$f":"\"<-- If \"&CELL(\"address\",B68)&\" is negative apply a red fill.\"","v":"<-- If $B$68 is negative apply a red fill."}]
[null,-1,12345,{"$f":"\"<-- If \"&CELL(\"address\",B69)&\" is negative apply a red fill.\"","v":"<-- If $B$69 is negative apply a red fill."}]
[null,"Be sure to use \"$\" correctly in conditional format rule formulas"]
[null,"if you wish to paste the cell format to other cells."]
["Protecting a Worksheet in a Workbook"]
[null,"By default all cells on a sheet are \"Locked\". You can see this by"]
[null,"selecting a cell range, right click, select \"Format Cells\" then the"]
[null,"Protection tab. Checking the locked box for a cell willhave no impact"]
[null,"until the worksheet is protected using the Review tab on the ribbon."]
[null,"Example:"]
[null,1,"The cells to the left are the only cell on this sheet which"]
[null,2,"were formatted with the \"Locked\" box unchecked using the"]
[null,3,"protection tab. To invoke the protection so that the only cells"]
[null,4,"able to be changed are the ones to the left, you must select"]
[null,5,"Review/Protect Sheet. Try it! Then undo the protection using"]
[null,6,"the Review tab."]
[null,"Remember, protecting the worksheet is a two step process. First, use"]
[null,"format protection to lock or unlock cells. Second, use the Review tab"]
[null,"on the ribbon to turn that protection on or off."]
[]
["Other Basic Excel Functions"]
[null,"Apples:",{"$f":"SUM(J90:J91,J94)","v":280},{"$f":"getformula(C89)","v":"<--  =SUM(J90:J91,J94)"},null,null,null,"Fruit","Year","Units"]
[null,"All but Pears",{"$f":"SUM(J90:J96)","v":1340},{"$f":"getformula(C90)","v":"<--  =SUM(J90:J96)"},null,null,null,"Apples",2018,50]
[null,"All but Pears",{"$f":"SUMIF(J90:J97,\"<400\")","v":1340},{"$f":"getformula(C91)","v":"<--  =SUMIF(J90:J97,\"<400\")"},null,null,null,"Apples",2019,100]
[null,"After 2019:",{"$f":"SUMIF(J90:J97,\"<>50\")","v":1690},{"$f":"getformula(C92)","v":"<--  =SUMIF(J90:J97,\"<>50\")"},null,null,null,"Oranges",2019,200]
[null,"Pears:",{"$f":"SUMIFS(J90:J97,H90:H97,\"PEARS\")","v":400},{"$f":"getformula(C93)","v":"<--  =SUMIFS(J90:J97,H90:H97,\"PEARS\")"},null,null,null,"Peaches",2019,300]
[null,"Apples 2018 & 2019",{"$f":"SUMIFS(J90:J97,H90:H97,\"Apples\",I90:I97,\"<2020\")","v":150},{"$f":"getformula(C94)","v":"<--  =SUMIFS(J90:J97,H90:H97,\"Apples\",I90:I97,\"<2020\")"},null,null,null,"Apples",2020,130]
[null,"Apples 2019:",{"$f":"SUMIFS(J90:J97,H90:H97,\"Apples\",I90:I97,2019)","v":100},{"$f":"getformula(C95)","v":"<--  =SUMIFS(J90:J97,H90:H97,\"Apples\",I90:I97,2019)"},null,null,null,"Oranges",2020,230]
[null,"Nonsence!:",{"$f":"SUMPRODUCT(I90:I97,J90:J97)","v":3514100},{"$f":"getformula(C96)","v":"<--  =SUMPRODUCT(I90:I97,J90:J97)"},null,null,null,"Peaches",2020,330]
[null,{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(B97,\"Error!\")","v":"Error!"},{"$f":"getformula(C97)","v":"<--  =IFERROR(B97,\"Error!\")"},null,null,null,"Pears",2020,400]
[null,"Average all:",{"$f":"AVERAGE(J90:J97)","v":217.5},{"$f":"getformula(C98)","v":"<--  =AVERAGE(J90:J97)"}]
[null,"2019 Average:",{"$f":"AVERAGEIF(I90:I97,\"=2019\",J90:J97)","v":200},{"$f":"getformula(C99)","v":"<--  =AVERAGEIF(I90:I97,\"=2019\",J90:J97)"}]
[null,"Samallest",{"$f":"MIN(J90:J97)","v":50},{"$f":"getformula(C100)","v":"<--  =MIN(J90:J97)"}]
[null,"Largest",{"$f":"MAX(J90:J97)","v":400},{"$f":"getformula(C101)","v":"<--  =MAX(J90:J97)"}]
[null,"Number",{"$f":"COUNT(J90:J97)","v":8},{"$f":"getformula(C102)","v":"<--  =COUNT(J90:J97)"}]
[null,"Row number",{"$f":"ROW(G88)","v":88},{"$f":"getformula(C103)","v":"<--  =ROW(G88)"}]