{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["VBA","Formula (2)","Formula","Dataset"],"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":"VBA","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Rounding to Significant Figures Using Custom Function"]
[]
[null,"Customer","Brand","Sales","Rounded Figure"]
[null,"Jonas","Lenovo",7611250,{"$f":"ROUNDSIGNIFICANT(D5,3)","v":7610000}]
[null,"Miller","Lenovo",1212690,{"$f":"ROUNDSIGNIFICANT(D6,3)","v":1210000}]
[null,"Abbie","Asus",2121250,{"$f":"ROUNDSIGNIFICANT(D7,3)","v":2120000}]
[null,"Nick","Asus",2145250,{"$f":"ROUNDSIGNIFICANT(D8,3)","v":2150000}]
[null,"Agnola","Acer",4565780,{"$f":"ROUNDSIGNIFICANT(D9,3)","v":4570000}]
[null,"Kane","HP",1892450,{"$f":"ROUNDSIGNIFICANT(D10,3)","v":1890000}]
[null,"Agnes","Acer",2671450,{"$f":"ROUNDSIGNIFICANT(D11,3)","v":2670000}]
[null,"Adorne","Lenovo",1269970,{"$f":"ROUNDSIGNIFICANT(D12,3)","v":1270000}]
[null,"Amie","Acer",2146550,{"$f":"ROUNDSIGNIFICANT(D13,3)","v":2150000}]
[null,"Alfreda","Dell",1178550,{"$f":"ROUNDSIGNIFICANT(D14,3)","v":1180000}]
[null,"Analise","Acer",4987580,{"$f":"ROUNDSIGNIFICANT(D15,3)","v":4990000}]
[null,"Alethea","Dell",1178780,{"$f":"ROUNDSIGNIFICANT(D16,3)","v":1180000}]
[null,"Adriane","HP",1189790,{"$f":"ROUNDSIGNIFICANT(D17,3)","v":1190000}]
[null,"Almira","HP",1247750,{"$f":"ROUNDSIGNIFICANT(D18,3)","v":1250000}]
[null,"Bob","Asus",1656660,{"$f":"ROUNDSIGNIFICANT(D19,3)","v":1660000}]
[null,"Amabel","Dell",1484460,{"$f":"ROUNDSIGNIFICANT(D20,3)","v":1480000}]

{"sheet":"Formula (2)","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Rounding to Significant Figures Using Formula"]
[]
[null,"Customer","Brand","Sales","Rounded Figure",null,"Significant Figure"]
[null,"Jonas","Lenovo",7611250,7611000,null,3]
[null,"Miller","Lenovo",1212690,{"$f":"ROUND(D6/10^(INT(LOG10(D6))+1),$G$5)*10^(INT(LOG10(D6))+1)","v":1210000}]
[null,"Abbie","Asus",2121250,2120000]
[null,"Nick","Asus",2145250,2150000]
[null,"Agnola","Acer",4565780,4570000]
[null,"Kane","HP",1892450,1890000]
[null,"Agnes","Acer",2671450,2670000]
[null,"Adorne","Lenovo",1269970,1270000]
[null,"Amie","Acer",2146550,2150000]
[null,"Alfreda","Dell",1178550,1180000]
[null,"Analise","Acer",4987580,4990000]
[null,"Alethea","Dell",1178780,1180000]
[null,"Adriane","HP",1189790,1190000]
[null,"Almira","HP",1247750,1250000]
[null,"Bob","Asus",1656660,1660000]
[null,"Amabel","Dell",1484460,1480000]

{"sheet":"Formula","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Rounding to Significant Figures Using Formula"]
[]
[null,"Customer","Brand","Sales","Rounded Figure"]
[null,"Jonas","Lenovo",7611250,{"$f":"ROUND(D5,3-(1+INT(LOG10(ABS(D5)))))","v":7610000}]
[null,"Miller","Lenovo",1212690,{"$f":"ROUND(D6,3-(1+INT(LOG10(ABS(D6)))))","v":1210000}]
[null,"Abbie","Asus",2121250,2120000]
[null,"Nick","Asus",2145250,2150000]
[null,"Agnola","Acer",4565780,4570000]
[null,"Kane","HP",1892450,1890000]
[null,"Agnes","Acer",2671450,2670000]
[null,"Adorne","Lenovo",1269970,1270000]
[null,"Amie","Acer",2146550,2150000]
[null,"Alfreda","Dell",1178550,1180000]
[null,"Analise","Acer",4987580,4990000]
[null,"Alethea","Dell",1178780,1180000]
[null,"Adriane","HP",1189790,1190000]
[null,"Almira","HP",1247750,1250000]
[null,"Bob","Asus",1656660,1660000]
[null,"Amabel","Dell",1484460,1480000]

{"sheet":"Dataset","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Rounding to Significant Figures in Excel"]
[]
[null,"Customer","Brand","Sales","Rounded Figure"]
[null,"Jonas","Lenovo",7611250]
[null,"Miller","Lenovo",1212690]
[null,"Abbie","Asus",2121250]
[null,"Nick","Asus",2145250]
[null,"Agnola","Acer",4565780]
[null,"Kane","HP",1892450]
[null,"Agnes","Acer",2671450]
[null,"Adorne","Lenovo",1269970]
[null,"Amie","Acer",2146550]
[null,"Alfreda","Dell",1178550]
[null,"Analise","Acer",4987580]
[null,"Alethea","Dell",1178780]
[null,"Adriane","HP",1189790]
[null,"Almira","HP",1247750]
[null,"Bob","Asus",1656660]
[null,"Amabel","Dell",1484460]