{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":0,"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":"Tabelle1","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Beispiel 1",null,null,"Onur","Onur (UDF)","Werner ","Edgar","Onur"]
[5,null,"Max",{"$f":"SUMIF(A4:A10,\">0\")","v":15},{"$f":"SuMinMax(A4:A10,TRUE)","v":15},{"$f":"(MAX(A4:A10)<=0)*MAX(A4:A10)+SUMIF(A4:A10,\">0\")","v":15},{"$f":"IF(MAX(A4:A10)<=0,MAX(A4:A10),SUMIF(A4:A10,\">0\"))","v":15},{"$f":"MAX(SUM(A4:A10)-A4:A10,MAX(SUM(A4:A10),MAX(A4:A10,-99999)))","v":15}]
[5,null,"Min",{"$f":"SUMIF(A4:A10,\"<0\")","v":0},{"$f":"SuMinMax(A4:A10,FALSE)","v":1},{"$f":"(MIN(A4:A10)>=0)*MIN(A4:A10)+SUMIF(A4:A10,\"<0\")","v":1},{"$f":"IF(MIN(A4:A10)>=0,MIN(A4:A10),SUMIF(A4:A10,\"<0\"))","v":1},{"$f":"MIN(SUM(A4:A10)-A4:A10,MIN(SUM(A4:A10),MIN(A4:A10,99999)))","v":1}]
[1]
[1]
[1]
[1]
[1]
["Beispiel 3",null,null,"Onur","Onur (UDF)","Werner ","Edgar","Onur"]
[-2,null,"Max",{"$f":"SUMIF(A12:A18,\">0\")","v":0},{"$f":"SuMinMax(A12:A18,TRUE)","v":-1},{"$f":"(MAX(A12:A18)<=0)*MAX(A12:A18)+SUMIF(A12:A18,\">0\")","v":-1},{"$f":"IF(MAX(A12:A18)<=0,MAX(A12:A18),SUMIF(A12:A18,\">0\"))","v":-1},{"$f":"MAX(SUM(A12:A18)-A12:A18,MAX(SUM(A12:A18),MAX(A12:A18,-99999)))","v":-1}]
[-2,null,"Min",{"$f":"SUMIF(A12:A18,\"<0\")","v":-24},{"$f":"SuMinMax(A12:A18,FALSE)","v":-24},{"$f":"(MIN(A12:A18)>=0)*MIN(A12:A18)+SUMIF(A12:A18,\"<0\")","v":-24},{"$f":"IF(MIN(A12:A18)>=0,MIN(A12:A18),SUMIF(A12:A18,\"<0\"))","v":-24},{"$f":"MIN(SUM(A12:A18)-A12:A18,MIN(SUM(A12:A18),MIN(A12:A18,99999)))","v":-24}]
[-6]
[-8]
[-1]
[-2]
[-3]
["Beispiel 3",null,null,"Onur","Onur (UDF)","Werner ","Edgar","Onur"]
[0,null,"Max",{"$f":"SUMIF(A20:A26,\">0\")","v":2},{"$f":"SuMinMax(A20:A26,TRUE)","v":2},{"$f":"(MAX(A20:A26)<=0)*MAX(A20:A26)+SUMIF(A20:A26,\">0\")","v":2},{"$f":"IF(MAX(A20:A26)<=0,MAX(A20:A26),SUMIF(A20:A26,\">0\"))","v":2},{"$f":"MAX(SUM(A20:A26)-A20:A26,MAX(SUM(A20:A26),MAX(A20:A26,-99999)))","v":2}]
[2,null,"Min",{"$f":"SUMIF(A20:A26,\"<0\")","v":0},{"$f":"SuMinMax(A20:A26,FALSE)","v":0},{"$f":"(MIN(A20:A26)>=0)*MIN(A20:A26)+SUMIF(A20:A26,\"<0\")","v":0},{"$f":"IF(MIN(A20:A26)>=0,MIN(A20:A26),SUMIF(A20:A26,\"<0\"))","v":0},{"$f":"MIN(SUM(A20:A26)-A20:A26,MIN(SUM(A20:A26),MIN(A20:A26,99999)))","v":0}]
[0]
[0]
[0]
[0]
[0]
["Beispiel 4",null,null,"Onur","Onur (UDF)","Werner ","Edgar","Onur"]
[1,null,"Max",{"$f":"SUMIF(A28:A34,\">0\")","v":8},{"$f":"SuMinMax(A28:A34,TRUE)","v":8},{"$f":"(MAX(A28:A34)<=0)*MAX(A28:A34)+SUMIF(A28:A34,\">0\")","v":8},{"$f":"IF(MAX(A28:A34)<=0,MAX(A28:A34),SUMIF(A28:A34,\">0\"))","v":8},{"$f":"MAX(SUM(A28:A34)-A28:A34,MAX(SUM(A28:A34),MAX(A28:A34,-99999)))","v":8}]
[2,null,"Min",{"$f":"SUMIF(A28:A34,\"<0\")","v":0},{"$f":"SuMinMax(A28:A34,FALSE)","v":1},{"$f":"(MIN(A28:A34)>=0)*MIN(A28:A34)+SUMIF(A28:A34,\"<0\")","v":1},{"$f":"IF(MIN(A28:A34)>=0,MIN(A28:A34),SUMIF(A28:A34,\"<0\"))","v":1},{"$f":"MIN(SUM(A28:A34)-A28:A34,MIN(SUM(A28:A34),MIN(A28:A34,99999)))","v":1}]
[1]
[1]
[1]
[1]
[1]