{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["IF Function","IF & ISBLANK Function","VBA"],"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":"IF Function","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Usage of IF Function"]
[]
[null,"Employee ID","Passport ID","Output"]
[null,"AK5053","245VW99204",{"$f":"IF(B5=\"\",C5,B5)","v":"AK5053"}]
[null,null,"245VW99552",{"$f":"IF(B6=\"\",C6,B6)","v":"245VW99552"}]
[null,null,"245VW99909","245VW99909"]
[null,"AK5056","245VW10025","AK5056"]
[null,null,"245VW10060","245VW10060"]
[null,"AK5058","245VW10095","AK5058"]
[null,"AK5059","245VW10130","AK5059"]
[null,null,"245VW10165","245VW10165"]
[null,"AK5061","245VW10200","AK5061"]
[null,null,"245VW10235",{"$f":"IF(B14=\"\",C14,B14)","v":"245VW10235"}]

{"sheet":"IF & ISBLANK Function","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Usage of IF & ISBLANK Function"]
[]
[null,"Employee ID","Passport ID","Output"]
[null,"AK5053","245VW99204",{"$f":"IF(ISBLANK(B5),C5,B5)","v":"AK5053"}]
[null,null,"245VW99552",{"$f":"IF(ISBLANK(B6),C6,B6)","v":"245VW99552"}]
[null,null,"245VW99909","245VW99909"]
[null,"AK5056","245VW10025","AK5056"]
[null,null,"245VW10060","245VW10060"]
[null,"AK5058","245VW10095","AK5058"]
[null,"AK5059","245VW10130","AK5059"]
[null,null,"245VW10165","245VW10165"]
[null,"AK5061","245VW10200","AK5061"]
[null,null,"245VW10235",{"$f":"IF(ISBLANK(B14),C14,B14)","v":"245VW10235"}]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of VBA Script"]
[]
[null,"Employee ID","Passport ID"]
[null,"AK5053","245VW99204"]
[null,"245VW99552","245VW99552"]
[null,"245VW99909","245VW99909"]
[null,"AK5056","245VW10025"]
[null,"245VW10060","245VW10060"]
[null,"AK5058","245VW10095"]
[null,"AK5059","245VW10130"]
[null,"245VW10165","245VW10165"]