{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["If Function","ISBLANK & IF function","ISNUMBER","Format Cell","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":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF Function"]
[]
[null,"Product Id","Quantity","Unit Price","Cost"]
[null,"A-051456",35,785,{"$f":"IF(C5=\"\",\"\",C5*D5)","v":27475}]
[null,"A-021547",54,6582,{"$f":"IF(C6=\"\",\"\",C6*D6)","v":355428}]
[null,"A-031021",null,156,""]
[null,"C-012145",73,145,10585]
[null,"B-000154",null,45,""]
[null,"A-032145",75,351,26325]
[null,"C-001458",95,254,24130]
[null,"D-562314",null,265,""]
[null,"F-652154",25,25,625]
[null,"A-201458",null,25,""]

{"sheet":"ISBLANK & IF function","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining IF & ISBLANK Function"]
[]
[null,"Product Id","Quantity","Unit Price","Cost"]
[null,"A-051456",35,785,{"$f":"IF(ISBLANK(C5), \"\", C5*D5)","v":27475}]
[null,"A-021547",54,6582,{"$f":"IF(ISBLANK(C6), \"\", C6*D6)","v":355428}]
[null,"A-031021",45,156,7020]
[null,"C-012145",73,145,10585]
[null,"B-000154",85,45,3825]
[null,"A-032145",null,351,""]
[null,"C-001458",95,254,24130]
[null,"D-562314",null,265,""]
[null,"F-652154",25,25,625]
[null,"A-201458",19,25,475]
[null,"C-125433",null,2500,""]
[null,"A-000521",25,58,1450]
[null,"B-658966",null,987,""]
[null,"B-021453",52,254,13208]
[null,"D-025144",85,658,55930]
[null,"D-458796",14,3521,49294]
[null,"E-785423",null,154,""]
[null,"E-983247",19,65,1235]
[null,"F-254136",39,195,7605]

{"sheet":"ISNUMBER","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying IF & ISNUMBER Function"]
[]
[null,"Product Id","Quantity","Unit Price","Cost","Formula Used"]
[null,"A-051456",35,785,{"$f":"IF(ISNUMBER(C5),C5*D5,\"\")","v":27475},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=IF(ISNUMBER(C5),C5*D5,\"\")"}]
[null,"A-021547",54,6582,{"$f":"IF(ISNUMBER(C6),C6*D6,\"\")","v":355428},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=IF(ISNUMBER(C6),C6*D6,\"\")"}]
[null,"A-031021",null,156,"","=IF(ISNUMBER(C7),C7*D7,\"\")"]
[null,"C-012145",73,145,10585,"=IF(ISNUMBER(C8),C8*D8,\"\")"]
[null,"B-000154",null,45,"","=IF(ISNUMBER(C9),C9*D9,\"\")"]
[null,"A-032145",75,351,26325,"=IF(ISNUMBER(C10),C10*D10,\"\")"]
[null,"C-001458",95,254,24130,"=IF(ISNUMBER(C11),C11*D11,\"\")"]
[null,"D-562314",null,265,"","=IF(ISNUMBER(C12),C12*D12,\"\")"]
[null,"F-652154",25,25,625,"=IF(ISNUMBER(C13),C13*D13,\"\")"]
[null,"A-201458",null,25,"","=IF(ISNUMBER(C14),C14*D14,\"\")"]

{"sheet":"Format Cell","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Custom Formatting"]
[]
[null,"Product Id","Quantity","Unit Price","Cost"]
[null,"A-051456",35,785,{"$f":"C5*D5","v":27475}]
[null,"A-021547",54,6582,{"$f":"C6*D6","v":355428}]
[null,"A-031021",null,156,0]
[null,"C-012145",73,145,10585]
[null,"B-000154",null,45,0]
[null,"A-032145",75,351,26325]
[null,"C-001458",95,254,24130]
[null,"D-562314",null,265,0]
[null,"F-652154",25,25,625]
[null,"A-201458",null,25,0]

{"sheet":"VBA ","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying IF & ISNUMBER Function"]
[]
[null,"Product Id","Quantity","Unit Price","Cost"]
[null,"A-051456",35,785,27475," "]
[null,"A-021547",54,6582,355428," "]
[null,"A-031021",null,156,0," "]
[null,"C-012145",73,145,10585," "]
[null,"B-000154",null,45,0," "]
[null,"A-032145",75,351,26325," "]
[null,"C-001458",95,254,24130," "]
[null,"D-562314",null,265,0," "]
[null,"F-652154",25,25,625," "]
[null,"A-201458",null,25,0," "]