{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Using Go To Special","Using IFERROR","Using ISERROR","Using IFNA","Using ISERR","Using ISNA","Using VBA","Using Ribbon","Practice Sheet"],"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":"Dataset","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"How to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,{"$f":"D5/C4","v":{"$error":"#VALUE!"}},null,"Coconut",{"$f":"VLOOKUP(G4,B4:E12,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$error":"#DIV/0!"}]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500,{"$f":"D","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit",11,{"$f":"#REF!/C10","v":{"$error":"#REF!"}},{"$f":"D10/C10","v":{"$error":"#REF!"}}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]
[null,null,"Total =",{"$f":"SUM(D4,D5,D6,D7,D8,D9,#REF!,D11,D12)","v":{"$error":"#REF!"}}]

{"sheet":"Using Go To Special","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using Go To Special to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,null,null,"Coconut"]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit",11]
[null,"Grape",12,840]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]
[null,null,"Total ="]

{"sheet":"Using IFERROR","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using IFERROR to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,{"$f":"IFERROR(D4/C4, \"Value Not Found\")","v":"Value Not Found"},null,"Coconut",{"$f":"IFERROR(VLOOKUP(G4,B4:E12,4,FALSE),\"Value Not Found\")","v":"Value Not Found"}]
[null,"Orange",9,540,{"$f":"IFERROR(D5/C5, \"Value Not Found\")","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$f":"IFERROR(D6/C6, \"Value Not Found\")","v":"Value Not Found"}]
[null,"Kiwi",18,2700,{"$f":"D7/C7","v":150}]
[null,"Cherry",12,1500,{"$f":"(D)","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit","FRUIT",4568,{"$f":"IFERROR(D10/C10,\"Value Not Found\")","v":"Value Not Found"}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]

{"sheet":"Using ISERROR","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using ISERROR to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,{"$f":"D4/C4","v":{"$error":"#VALUE!"}},null,"Coconut",{"$f":"ISERROR(VLOOKUP(G4,B4:E12,4,FALSE))","v":true}]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$error":"#DIV/0!"}]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500,{"$f":"D","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit","FRUIT",4568,{"$f":"D10/C10","v":{"$error":"#VALUE!"}}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]

{"sheet":"Using IFNA","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using IFNA to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,{"$f":"_xlfn.IFNA(D4/C4,0)","v":{"$error":"#VALUE!"}},null,"Coconut",{"$f":"_xlfn.IFNA(VLOOKUP(G4,B4:E12,4,FALSE),0)","v":0}]
[null,"Orange",9,540,{"$f":"_xlfn.IFNA(D5/C5,0)","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$error":"#DIV/0!"}]
[null,"Kiwi",18,2700,{"$f":"D7/C7","v":150}]
[null,"Cherry",12,1500,{"$f":"D","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit",11,390,{"$f":"D10/C10","v":35.454545454545453}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]
[null,null,null,"Total =",{"$f":"_xlfn.IFNA(SUM(E4:E12),0)","v":{"$error":"#VALUE!"}}]

{"sheet":"Using ISERR","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using ISERR to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,{"$f":"ISERR(D4/C4)","v":true},null,"Coconut",{"$f":"ISERR(VLOOKUP(G4,B4:E12,4,FALSE))","v":false}]
[null,"Orange",9,540,{"$f":"ISERR(D5/C5)","v":false},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":false}]
[null,"Strawberry",null,750,true]
[null,"Kiwi",18,2700,false]
[null,"Cherry",12,1500,false]
[null,"Blackberry",10,2000,false]
[null,"Dragon Fruit",null,390,true]
[null,"Grape",12,840,false]
[null,"Avacado",13,2340,false]

{"sheet":"Using ISNA","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using ISNA to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price Per Kg"]
[null,"Apple","Apple",935,{"$f":"ISNA(D4/C4)","v":false},null,"Coconut",{"$f":"ISNA(VLOOKUP(G4,B4:E12,4,FALSE))","v":true}]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$error":"#DIV/0!"}]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500,{"$f":"D","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit",11,390,{"$f":"D10/C10","v":35.454545454545453}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]

{"sheet":"Using VBA","index":7,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using VBA to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price/Kg"]
[null,"Apple","Apple",935,null,null,"Coconut"]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E12,4,FALSE)","v":60}]
[null,"Strawberry",null,750]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Grape",12,840,{"$f":"D10/C10","v":70}]
[null,"Avacado",13,2340]

{"sheet":"Using Ribbon","index":8,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using Ribbon to Remove Error in Excel"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price/ Kg"]
[null,"Apple","Apple",935,{"$f":"D4/C4","v":{"$error":"#VALUE!"}},null,"Coconut",{"$f":"VLOOKUP(G4,B4:E12,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$error":"#DIV/0!"}]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500,{"$f":"D","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit",11,{"$f":"#REF!/C10","v":{"$error":"#REF!"}},{"$f":"D10/C10","v":{"$error":"#REF!"}}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]
[null,null,"Total =",{"$f":"SUM(D4,D5,D6,D7,D8,D9,#REF!,D11,D12)","v":{"$error":"#REF!"}}]

{"sheet":"Practice Sheet","index":9,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Do it YourSelf"]
[]
[null,"Product ","Amount (Kg)","Total Price","Price/Kg",null,"LookUp","Price/ Kg"]
[null,"Apple","Apple",935,{"$f":"D4/C4","v":{"$error":"#VALUE!"}},null,"Coconut",{"$f":"VLOOKUP(G4,B4:E12,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"Orange",9,540,{"$f":"D5/C5","v":60},null,"Orange",{"$f":"VLOOKUP(G5,B5:E13,4,FALSE)","v":60}]
[null,"Strawberry",null,750,{"$error":"#DIV/0!"}]
[null,"Kiwi",18,2700,150]
[null,"Cherry",12,1500,{"$f":"D","v":{"$error":"#NAME?"}}]
[null,"Blackberry",10,2000,{"$f":"D9/C9","v":200}]
[null,"Dragon Fruit",11,{"$f":"#REF!/C10","v":{"$error":"#REF!"}},{"$f":"D10/C10","v":{"$error":"#REF!"}}]
[null,"Grape",12,840,{"$f":"D11 C11","v":{"$error":"#NULL!"}}]
[null,"Avacado",13,2340,{"$f":"D12/C12","v":180}]
[null,null,"Total =",{"$f":"SUM(D4,D5,D6,D7,D8,D9,#REF!,D11,D12)","v":{"$error":"#REF!"}}]