{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,13,20,13],[19,15,20,15],[19,14,20,14]]}
[]
[null,null,null,"数値",-34.56,-12.5,-12.34,-11.5,0,11.5,12.34,12.5,34.56]
[null,"セルの表示形式",1,"整数のみ",{"$f":"E2","v":-34.56},{"$f":"F2","v":-12.5},-12.34,-11.5,0,11.5,12.34,12.5,34.56,"①","四捨五入系","→"]
[null,"ワークシート関数",2,"=TRUNC(数値,[桁数=0])",{"$f":"TRUNC(E2)","v":-34},{"$f":"TRUNC(F2)","v":-12},-12,-11,0,11,12,12,34,"②","切り捨て系","⤵"]
[null,null,3,"=INT(数値)",{"$f":"INT(E2)","v":-35},{"$f":"INT(F2)","v":-13},-13,-12,0,11,12,12,34,"③","切り捨て系","⤵"]
[null,null,4,"=ROUND(数値,[桁数=0])",{"$f":"ROUND(E2,0)","v":-35},{"$f":"ROUND(F2,0)","v":-13},-12,-12,0,12,12,13,35,"①","四捨五入系","→"]
[null,null,5,"=ROUNDUP(数値,[桁数=0])",{"$f":"ROUNDUP(E2,0)","v":-35},{"$f":"ROUNDUP(F2,0)","v":-13},-13,-12,0,12,13,13,35,"④","切り上げ系","⤴"]
[null,null,6,"=ROUNDDOWN(数値,[桁数=0])",{"$f":"ROUNDDOWN(E2,0)","v":-34},{"$f":"ROUNDDOWN(F2,0)","v":-12},-12,-11,0,11,12,12,34,"②","切り捨て系","⤵"]
[null,null,7,"=FIXED(数値,桁数=0,桁区切り)",{"$f":"FIXED(E2,0)","v":"-35"},{"$f":"FIXED(F2,0)","v":"-13"},"-12","-12","0","12","12","13","35","①","四捨五入系","→"]
[null,null,8,"=TEXT(値,表示形式=\"0\")",{"$f":"TEXT(E2,\"0\")","v":"-35"},{"$f":"TEXT(F2,\"0\")","v":"-13"},"-12","-12","0","12","12","13","35","①","四捨五入系","→"]
[null,null,9,"=FLOOR(数値,基準値=1)",{"$f":"FLOOR(E2,1)","v":-35},{"$f":"FLOOR(F2,1)","v":-13},-13,-12,0,11,12,12,34,"③","切り捨て系","⤵"]
[null,null,10,"=FLOOR.MATH(数値,基準値=1,モード=0)",{"$f":"_xlfn.FLOOR.MATH(E2,1,0)","v":-35},{"$f":"_xlfn.FLOOR.MATH(F2,1,0)","v":-13},-13,-12,0,11,12,12,34,"③","切り捨て系","⤵"]
[null,null,11,"=FLOOR.MATH(数値,基準値=1,モード=1)",{"$f":"_xlfn.FLOOR.MATH(E2,1,1)","v":-34},{"$f":"_xlfn.FLOOR.MATH(F2,1,1)","v":-12},-12,-11,0,11,12,12,34,"②","切り捨て系","⤵"]
[null,null,12,"=FLOOR.PRECISE(数値,基準値=1)",{"$f":"_xlfn.FLOOR.PRECISE(E2,1)","v":-35},{"$f":"_xlfn.FLOOR.PRECISE(F2,1)","v":-13},-13,-12,0,11,12,12,34,"③","切り捨て系","⤵"]
[null,null,13,"=CEILING(数値,基準値=1)",{"$f":"CEILING(E2,1)","v":-34},{"$f":"CEILING(F2,1)","v":-12},-12,-11,0,12,13,13,35,"⑤","切り上げ系","⤴"]
[null,null,14,"=CEILING.MATH(数値,基準値=1,モード=0)",{"$f":"_xlfn.CEILING.MATH(E2,1,0)","v":-34},{"$f":"_xlfn.CEILING.MATH(F2,1,0)","v":-12},-12,-11,0,12,13,13,35,"⑤","切り上げ系","⤴"]
[null,null,15,"=CEILING.MATH(数値,基準値=1,モード=1)",{"$f":"_xlfn.CEILING.MATH(E2,1,1)","v":-35},{"$f":"_xlfn.CEILING.MATH(F2,1,1)","v":-13},-13,-12,0,12,13,13,35,"④","切り上げ系","⤴"]
[null,null,16,"=ISO.CEILING(数値,基準値=1)",{"$f":"ISO.CEILING(E2,1)","v":-34},{"$f":"ISO.CEILING(F2,1)","v":-12},-12,-11,0,12,13,13,35,"⑤","切り上げ系","⤴"]
[null,null,17,"=CEILING.PRECISE(数値,基準値=1)",{"$f":"_xlfn.CEILING.PRECISE(E2,1)","v":-34},{"$f":"_xlfn.CEILING.PRECISE(F2,1)","v":-12},-12,-11,0,12,13,13,35,"⑤","切り上げ系","⤴"]
[null,null,18,"=MROUND(数値,基準値=1)",{"$f":"MROUND(E2,1)","v":{"$error":"#NUM!"}},{"$f":"MROUND(F2,1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},0,12,12,13,35,"①","四捨五入系","→"]
[null,null,19,"=MROUND(数値,基準値=-1)",{"$f":"MROUND(E2,-1)","v":-35},{"$f":"MROUND(F2,-1)","v":-13},-12,-12,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,20,"=EVEN(数値)",{"$f":"EVEN(E2)","v":-36},{"$f":"EVEN(F2)","v":-14},-14,-12,0,12,14,14,36]
[null,null,21,"=ODD(数値)",{"$f":"ODD(E2)","v":-35},{"$f":"ODD(F2)","v":-13},-13,-13,1,13,13,13,35]
[null,null,22,"0.5足してInt（四捨五入相当）",{"$f":"INT(E2+0.5)","v":-35},{"$f":"INT(F2+0.5)","v":-12},-12,-11,0,12,12,13,35,"①","四捨五入系","→"]
[null,"VBA関数",23,"Int(数値)",{"$f":"vba_int(E2)","v":-35},{"$f":"vba_int(F2)","v":-13},-13,-12,0,11,12,12,34,"③","切り捨て系","⤵"]
[null,null,24,"Fix(数値)",{"$f":"vba_fix(E2)","v":-34},{"$f":"vba_fix(F2)","v":-12},-12,-11,0,11,12,12,34,"②","切り捨て系","⤵"]
[null,null,25,"Round(数値,桁数=0)",{"$f":"vba_round(E2)","v":-35},{"$f":"vba_round(F2)","v":-12},-12,-12,0,12,12,12,35,"①","四捨五入系","→"]
[null,null,26,"Format(値,書式=\"0\")",{"$f":"vba_format(E2)","v":-35},{"$f":"vba_format(F2)","v":-13},-12,-12,0,12,12,13,35,"①","四捨五入系","→"]
[null,null,27,"1足してInt（切り上げ相当）",{"$f":"vba_1(E2)","v":-34},{"$f":"vba_1(F2)","v":-12},-12,-11,1,12,13,13,35,"⑤","切り上げ系","⤴"]
[null,null,28,"0.5足してInt（四捨五入相当）",{"$f":"vba_05(E2)","v":-35},{"$f":"vba_05(F2)","v":-12},-12,-11,0,12,12,13,35,"①","四捨五入系","→"]

{"sheet":"Sheet2","index":1,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[100,null,null,null,null,null,100]
[-100,null,null,null,null,null,-100]
[2000,null,null,null,null,null,2000]
[-2000,null,null,null,null,null,-2000]