{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvod","IIF","Poznámky"],"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":"Úvod","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,11],[1,2,1,9],[11,2,12,6],[14,3,15,6],[15,7,15,9]]}
[]
[null,null,"Jak na Excel "]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"IIF"]
[]
[]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"http://office.lasakovi.com/excel/vba-teorie-zaklady/iif-excel-vba/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017 rev 2019, 2021"]

{"sheet":"IIF","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,1,3,2],[4,1,4,2],[5,1,5,2],[0,0,0,4],[1,0,1,4]]}
["Iif     Excel VBA"]
["http://office.lasakovi.com"]
[]
[null,"03_VBA_Zaklady - Konstrukce",null,"Složka"]
[null,"03b - VBA Zaklad IIf.xlsm",null,"Sešit"]
[null,"IIF",null,"List"]
[]
[]
[]
[]
[]
[null,"SYNTAXE"]
[null,"IIf(podmínka, pokud_pravdiva, pokud_nepravdiva)"]
[]
[]
[]
[null,"Úkol"]
[null,"Odpověď na otázku ANO / NE"]
[]
[]
[]
[null,"i = MsgBox(\"Chcete větši plat?\", vbYesNo, \"Plat\")"]
[null,"MsgBox (IIf(i = vbYes, \"Vaše odpověď ANO.\", \"Vaše odpověď NE.\"))"]
[]
[]
[]
[]
[]
[]
[null,"i = MsgBox(\"Chcete větši plat?\", vbYesNo, \"Plat\")"]
[null,"MsgBox (IIf(i = vbNo, \"Vaše odpověď NE.\", \"Vaše odpověď ANO.\"))"]

{"sheet":"Poznámky","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Iif     Excel VBA"]
["http://office.lasakovi.com"]
[]
[null,"Prostor pro poznámky"]