{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[1,null,"IF関数　条件２つ",{"$f":"IF(A1=1,\"X\",IF(A2>2,\"Y\",\"Z\"))","v":"X"},"VBAでユーザー定義関数",{"$f":"myif(A1,A2)","v":"X"}]
[2,null,"IF関数　条件２つ＋ANDとOR組み合わせ",{"$f":"IF(AND(A1=1,A2>2),\"X\",IF(OR(A3=3,A4<4),\"Y\", \"Z\"))","v":"Y"},"VBAでユーザー定義関数",{"$f":"myIf2(A1,A2,A3,A4)","v":"Y"},null,null,"エクセル関数"]
[3,null,"IFS関数　条件３つ＋ANDとOR組み合わせ",{"$f":"_xlfn.IFS(\n   AND(A1=1,A2>2),\"X\",\n   OR(A3=3,A4<4),\"Y\",\n   TRUE,\"Z\"\n   )","v":"Y"}]
[4,null,null,null,null,null,null,null,"ユーザー定義関数"]
[5,null,"SWITCH関数　A1基準",{"$f":"_xlfn.SWITCH(A1,1,\"X\",2,\"Y\",\"Z\")","v":"X"},"VBAでユーザー定義関数",{"$f":"mySwitch(A1)","v":"X"}]
[]
[null,null,"SWITCH関数　TRUE基準",{"$f":"_xlfn.SWITCH(TRUE,A1>=2,\"X\",A2>=2,\"Y\",\"Z\")","v":"Y"}]
[]
["選手名","スコア","Prize",null,"Prize2",null,"Prize3"]
["Aさん",52,{"$f":"Prize(B10,B$17,B$18,B$19,B$20)","v":"銅メダル"},null,{"$f":"Prize2(B10,B$17,B$18,B$19,B$20)","v":"メダル獲得"},null,{"$f":"Prize3(B10,B$17,B$18,B$19,B$20)","v":"メダル獲得"}]
["Bさん",42,{"$f":"Prize(B11,B$17,B$18,B$19,B$20)","v":""},null,{"$f":"Prize2(B11,B$17,B$18,B$19,B$20)","v":""},null,{"$f":"Prize3(B11,B$17,B$18,B$19,B$20)","v":""}]
["Cさん",48,{"$f":"Prize(B12,B$17,B$18,B$19,B$20)","v":"入賞"},null,{"$f":"Prize2(B12,B$17,B$18,B$19,B$20)","v":"入賞"},null,{"$f":"Prize3(B12,B$17,B$18,B$19,B$20)","v":"入賞"}]
["Dさん",66,{"$f":"Prize(B13,B$17,B$18,B$19,B$20)","v":"金メダル"},null,{"$f":"Prize2(B13,B$17,B$18,B$19,B$20)","v":"メダル獲得"},null,{"$f":"Prize3(B13,B$17,B$18,B$19,B$20)","v":"メダル獲得"}]
["Eさん",59,{"$f":"Prize(B14,B$17,B$18,B$19,B$20)","v":"銀メダル"},null,{"$f":"Prize2(B14,B$17,B$18,B$19,B$20)","v":"メダル獲得"},null,{"$f":"Prize3(B14,B$17,B$18,B$19,B$20)","v":"メダル獲得"}]
["Fさん",43,{"$f":"Prize(B15,B$17,B$18,B$19,B$20)","v":"入賞"},null,{"$f":"Prize2(B15,B$17,B$18,B$19,B$20)","v":"入賞"},null,{"$f":"Prize3(B15,B$17,B$18,B$19,B$20)","v":"入賞"}]
["Gさん",38,{"$f":"Prize(B16,B$17,B$18,B$19,B$20)","v":""},null,{"$f":"Prize2(B16,B$17,B$18,B$19,B$20)","v":""},null,{"$f":"Prize3(B16,B$17,B$18,B$19,B$20)","v":""}]
["最高得点",{"$f":"MAX(B10:B16)","v":66}]
["2位",{"$f":"LARGE(B10:B16,2)","v":59}]
["3位",{"$f":"LARGE(B10:B16,3)","v":52}]
["5位",{"$f":"LARGE(B10:B16,5)","v":43}]