{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Лист1","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,23,9]]}
[null,null,null,null,null,null,"Сумма чётных больше чем нечётных","Сумма чётных больше 4.5","Сумма нечётных больше 7.5"]
[255313,1,9,4,{"$f":"SUM(B2:D2)","v":14},null,{"$f":"IF(SUM(IF(MOD(B2:D2,2)=0,B2:D2,0))>SUM(IF(MOD(B2:D2,2)=1,B2:D2,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B2:D2,2)=0,B2:D2,0))>4.5,\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B2:D2,2)=1,B2:D2,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255314,2,4,1,{"$f":"SUM(B3:D3)","v":7},null,{"$f":"IF(SUM(IF(MOD(B3:D3,2)=0,B3:D3,0))>SUM(IF(MOD(B3:D3,2)=1,B3:D3,0)),\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B3:D3,2)=0,B3:D3,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B3:D3,2)=1,B3:D3,0))>7.5,\"ДА\",\"НЕТ\")","v":"НЕТ"}]
[255315,4,9,5,18,null,{"$f":"IF(SUM(IF(MOD(B4:D4,2)=0,B4:D4,0))>SUM(IF(MOD(B4:D4,2)=1,B4:D4,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B4:D4,2)=0,B4:D4,0))>4.5,\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B4:D4,2)=1,B4:D4,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255316,0,4,2,6,null,{"$f":"IF(SUM(IF(MOD(B5:D5,2)=0,B5:D5,0))>SUM(IF(MOD(B5:D5,2)=1,B5:D5,0)),\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B5:D5,2)=0,B5:D5,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B5:D5,2)=1,B5:D5,0))>7.5,\"ДА\",\"НЕТ\")","v":"НЕТ"}]
[255317,3,6,5,14,null,{"$f":"IF(SUM(IF(MOD(B6:D6,2)=0,B6:D6,0))>SUM(IF(MOD(B6:D6,2)=1,B6:D6,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B6:D6,2)=0,B6:D6,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B6:D6,2)=1,B6:D6,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255318,1,7,9,17,null,{"$f":"IF(SUM(IF(MOD(B7:D7,2)=0,B7:D7,0))>SUM(IF(MOD(B7:D7,2)=1,B7:D7,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B7:D7,2)=0,B7:D7,0))>4.5,\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B7:D7,2)=1,B7:D7,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255319,5,7,5,17,null,{"$f":"IF(SUM(IF(MOD(B8:D8,2)=0,B8:D8,0))>SUM(IF(MOD(B8:D8,2)=1,B8:D8,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B8:D8,2)=0,B8:D8,0))>4.5,\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B8:D8,2)=1,B8:D8,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255320,4,9,4,17,null,{"$f":"IF(SUM(IF(MOD(B9:D9,2)=0,B9:D9,0))>SUM(IF(MOD(B9:D9,2)=1,B9:D9,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B9:D9,2)=0,B9:D9,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B9:D9,2)=1,B9:D9,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255321,6,1,1,8,null,{"$f":"IF(SUM(IF(MOD(B10:D10,2)=0,B10:D10,0))>SUM(IF(MOD(B10:D10,2)=1,B10:D10,0)),\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B10:D10,2)=0,B10:D10,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B10:D10,2)=1,B10:D10,0))>7.5,\"ДА\",\"НЕТ\")","v":"НЕТ"}]
[255322,3,5,6,14,null,{"$f":"IF(SUM(IF(MOD(B11:D11,2)=0,B11:D11,0))>SUM(IF(MOD(B11:D11,2)=1,B11:D11,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B11:D11,2)=0,B11:D11,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B11:D11,2)=1,B11:D11,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255323,7,0,6,13,null,{"$f":"IF(SUM(IF(MOD(B12:D12,2)=0,B12:D12,0))>SUM(IF(MOD(B12:D12,2)=1,B12:D12,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B12:D12,2)=0,B12:D12,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B12:D12,2)=1,B12:D12,0))>7.5,\"ДА\",\"НЕТ\")","v":"НЕТ"}]
[255324,4,5,5,14,null,{"$f":"IF(SUM(IF(MOD(B13:D13,2)=0,B13:D13,0))>SUM(IF(MOD(B13:D13,2)=1,B13:D13,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B13:D13,2)=0,B13:D13,0))>4.5,\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B13:D13,2)=1,B13:D13,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255325,9,6,3,18,null,{"$f":"IF(SUM(IF(MOD(B14:D14,2)=0,B14:D14,0))>SUM(IF(MOD(B14:D14,2)=1,B14:D14,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B14:D14,2)=0,B14:D14,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B14:D14,2)=1,B14:D14,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255326,5,7,9,21,null,{"$f":"IF(SUM(IF(MOD(B15:D15,2)=0,B15:D15,0))>SUM(IF(MOD(B15:D15,2)=1,B15:D15,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B15:D15,2)=0,B15:D15,0))>4.5,\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B15:D15,2)=1,B15:D15,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255327,2,5,8,15,null,{"$f":"IF(SUM(IF(MOD(B16:D16,2)=0,B16:D16,0))>SUM(IF(MOD(B16:D16,2)=1,B16:D16,0)),\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B16:D16,2)=0,B16:D16,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B16:D16,2)=1,B16:D16,0))>7.5,\"ДА\",\"НЕТ\")","v":"НЕТ"}]
[255328,9,7,8,24,null,{"$f":"IF(SUM(IF(MOD(B17:D17,2)=0,B17:D17,0))>SUM(IF(MOD(B17:D17,2)=1,B17:D17,0)),\"ДА\",\"НЕТ\")","v":"НЕТ"},{"$f":"IF(SUM(IF(MOD(B17:D17,2)=0,B17:D17,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B17:D17,2)=1,B17:D17,0))>7.5,\"ДА\",\"НЕТ\")","v":"ДА"}]
[255329,8,5,1,14,null,{"$f":"IF(SUM(IF(MOD(B18:D18,2)=0,B18:D18,0))>SUM(IF(MOD(B18:D18,2)=1,B18:D18,0)),\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B18:D18,2)=0,B18:D18,0))>4.5,\"ДА\",\"НЕТ\")","v":"ДА"},{"$f":"IF(SUM(IF(MOD(B18:D18,2)=1,B18:D18,0))>7.5,\"ДА\",\"НЕТ\")","v":"НЕТ"}]
[]
["Здравствуйте! Не хватает знаний, помогите пожалуйста создать формулу.В диапазоне B2:D2,  ЕСЛИ сума чётных больше чем сумма нечётных, то \"ДА\", аналогично Сумма чётных больше 4,5 и Сумма нечётных больше 7,5. В противном случае значение \"НЕТ\""]