{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Contents","Introduction MOD","13 MOD 4","Basic Math","Every other row","Every Nth row","MOD Sum on Columns","Highlighted Nth row","concatenate every n cells","Count odd cells","Repeating Pattern"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["MOD Function"]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction MOD",null,null,null,"Excel Formulas w/Examples"]
[null,"13 MOD 4",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Basic Math",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Every other row"]
[null,"Every Nth row"]
[null,"MOD Sum on Columns"]
[null,"Highlighted Nth row"]
[null,"concatenate every n cells"]
[null,"Count odd cells"]
[null,"Repeating Pattern"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction MOD","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MOD",null,"=MOD (number, divisor)"]
[null,"The Excel MOD function returns the remainder of two numbers after division."]
[]
[null,"Number","Divisor","Result"]
[null,152,1,{"$f":"MOD(B6,C6)","v":0}]
[null,152,3,{"$f":"MOD(B7,C7)","v":2}]
[null,152,7,5]
[null,152,10,2]
[null,152,11,9]
[null,152,100,52]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"13 MOD 4","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Result"]
[{"$f":"MOD(13,4)","v":1}]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic Math","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Input","MOD of 3"]
[{"$f":"ROW()","v":2},{"$f":"MOD(A2,3)","v":2}]
[{"$f":"ROW()","v":3},{"$f":"MOD(A3,3)","v":0}]
[{"$f":"ROW()","v":4},1]
[{"$f":"ROW()","v":5},2]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Every other row","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Input","Mod 2"]
[{"$f":"ROW()","v":2},{"$f":"MOD(A2,2)","v":0}]
[{"$f":"ROW()","v":3},{"$f":"MOD(A3,2)","v":1}]
[{"$f":"ROW()","v":4},0]
[{"$f":"ROW()","v":5},1]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Every Nth row","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[4,0,5,0],[7,0,8,0]]}
["Shift","Product","Sales",null,"Result"]
["Morning","Cogs",10,null,{"$f":"SUMPRODUCT(C2:C10, --(MOD(ROW(A2:A10)+2, 3)=0))","v":90}]
[null,"Widgets",20]
["Morning Total",null,{"$f":"SUM(C2:C3)","v":30}]
["Aftenroon","Cogs",15]
[null,"Widgets",25]
["Afternoon Total",null,{"$f":"SUM(C5:C6)","v":40}]
["Evening","Cogs",7]
[null,"Widgets",13]
["Evening Total",null,{"$f":"SUM(C8:C9)","v":20}]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"MOD Sum on Columns","index":6,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Jan Items","Jan Sales","Feb Items","Feb Sales",null,"Result"]
["Adam",2,500,5,800,null,{"$f":"SUMPRODUCT(B2:E2*(MOD(COLUMN(B2:E2),2)=0))","v":7}]
[]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Highlighted Nth row","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[4,0,5,0],[7,0,8,0]]}
["Shift","Product","Sales",null,"Result"]
["Morning","Cogs",10,null,{"$f":"SUMPRODUCT(C2:C10, --(MOD(ROW(A2:A10)+2, 3)=0))","v":90}]
[null,"Widgets",20]
["Morning Total",null,{"$f":"SUM(C2:C3)","v":30}]
["Aftenroon","Cogs",15]
[null,"Widgets",25]
["Afternoon Total",null,{"$f":"SUM(C5:C6)","v":40}]
["Evening","Cogs",7]
[null,"Widgets",13]
["Evening Total",null,{"$f":"SUM(C8:C9)","v":20}]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"concatenate every n cells","index":8,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Raw Date","Our Formula"]
["Sophia",{"$f":"IF(MOD(ROW()+1, 3)=0, CONCATENATE(A2,\" \", A3,\" \", A4), \"\")","v":"Sophia Isabella Emma"}]
["Isabella",""]
["Emma",""]
["Olivia","Olivia Addison Natalie"]
["Addison",""]
["Natalie",""]
["Hailey","Hailey Renee Smith"]
["Renee",""]
["Smith",""]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Count odd cells","index":9,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Values",null,"Result"]
[5,null,{"$f":"SUMPRODUCT(1*(MOD(A2:A7, 2)=1))","v":5}]
[5]
[3]
[3]
[2]
[1]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Repeating Pattern","index":10,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Starting List",null,"Final Output"]
["Mon",null,{"$f":"INDEX(MyList[],MOD(ROW(A1)-1,3)+1)","v":"Mon"}]
["Wed",null,{"$f":"INDEX(MyList[],MOD(ROW(A2)-1,3)+1)","v":"Wed"}]
["Fri",null,{"$f":"INDEX(MyList[],MOD(ROW(A3)-1,3)+1)","v":"Fri"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A4)-1,3)+1)","v":"Mon"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A5)-1,3)+1)","v":"Wed"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A6)-1,3)+1)","v":"Fri"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A7)-1,3)+1)","v":"Mon"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A8)-1,3)+1)","v":"Wed"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A9)-1,3)+1)","v":"Fri"}]
[null,null,{"$f":"INDEX(MyList[],MOD(ROW(A10)-1,3)+1)","v":"Mon"}]
[]
[]
[null,"automateexcel.com/functions/mod-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]