{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview_SIGN Function","Dataset_SIGN","Basic1","Basic2","Comparing","Percentage Change","SIGN_IFERROR","SIGN_VLOOKUP","SIGN_SUMPRODUCT","SIGN_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":"Overview_SIGN Function","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel SIGN Function: Overview"]
[]
[null,"Number","Output","Formula","Explanation"]
[null,{"$f":"_xlfn.SHEETS()","v":10},{"$f":"SIGN(B5)","v":1},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=SIGN(B5)"},"Returns 1 as the input is a positive number"]
[null,0,{"$f":"SIGN(B6)","v":0},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=SIGN(B6)"},"Returns 0 as the input is zero"]
[null,-8,-1,"=SIGN(B7)","Returns -1 as the input is a negative number"]
[null,0.58779999999999999,1,"=SIGN(B8)","Returns 1 as the input is a positive decimal number"]
[null,-0.58779999999999999,-1,"=SIGN(B9)","Returns -1 as the input is a negative decimal number"]
[null,100000,{"$f":"SIGN(B10)","v":1},"=SIGN(B10)","Returns 1 as the input is a positive number in scientific format"]
[null,-100000,{"$f":"SIGN(B11)","v":-1},"=SIGN(B11)","Returns 1 as the input is a negative number in scientific format"]
[null,"Apple",{"$f":"SIGN(B12)","v":{"$error":"#VALUE!"}},"=SIGN(B12)","Returns #VALUE! Error as the input is a text"]

{"sheet":"Dataset_SIGN","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset for the Usage of SIGN Function"]
[]
[null,"Item","States","Price at January","Price at February"]
[null,"Apple","Ohio",30,35]
[null,"Banana","Utah",20,25]
[null,"Carrots","Nevada",50,45]
[null,"Garlic","Ohio",40,35]
[null,"Apple","Utah",40,45]
[null,"Garlic","Nevada",30,25]
[null,"Carrots","Utah",60,50]

{"sheet":"Basic1","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,5,1,7],[1,1,1,3]]}
[]
[null,"Basic Application of The SIGN Function",null,null,null,"Changing the Sign of Number"]
[]
[null,"Number","Output","Formula",null,"Number","Output","Formula"]
[null,{"$f":"_xlfn.SHEETS()","v":10},{"$f":"SIGN(B5)","v":1},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=SIGN(B5)"},null,1000,{"$f":"F5*SIGN(F5)","v":1000},{"$f":"_xlfn.FORMULATEXT(G5)","v":"=F5*SIGN(F5)"}]
[null,0,{"$f":"SIGN(B6)","v":0},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=SIGN(B6)"},null,-450,{"$f":"F6*SIGN(F6)","v":450},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=F6*SIGN(F6)"}]
[null,-8,-1,"=SIGN(B7)",null,808,808,"=F7*SIGN(F7)"]
[null,0.58779999999999999,1,"=SIGN(B8)",null,-34,34,"=F8*SIGN(F8)"]
[null,-0.58779999999999999,-1,"=SIGN(B9)",null,530,530,"=F9*SIGN(F9)"]
[null,100000,{"$f":"SIGN(B10)","v":1},"=SIGN(B10)",null,-794,794,"=F10*SIGN(F10)"]
[null,-100000,{"$f":"SIGN(B11)","v":-1},"=SIGN(B11)"]

{"sheet":"Basic2","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Changing the Sign of Number"]
[]
[null,"Number","Output","Formula"]
[null,1000,{"$f":"B5*SIGN(B5)","v":1000},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=B5*SIGN(B5)"}]
[null,-450,{"$f":"B6*SIGN(B6)","v":450},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=B6*SIGN(B6)"}]
[null,808,808,"=B7*SIGN(B7)"]
[null,-34,34,"=B8*SIGN(B8)"]
[null,530,530,"=B9*SIGN(B9)"]
[null,-794,794,"=B10*SIGN(B10)"]

{"sheet":"Comparing","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using The SIGN Function to Compare Two Data"]
[]
[null,"Item","States","Price at January","Price at February","Comparison"]
[null,"Apple","Ohio",30,35,{"$f":"SIGN(E5-D5)","v":1}]
[null,"Banana","Utah",20,25,{"$f":"SIGN(E6-D6)","v":1}]
[null,"Carrots","Nevada",50,45,-1]
[null,"Garlic","Ohio",40,35,-1]
[null,"Apple","Utah",40,45,1]
[null,"Garlic","Nevada",30,25,-1]
[null,"Carrots","Utah",60,50,-1]

{"sheet":"Percentage Change","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Determining Percentage Change Utilizing The SIGN Function"]
[]
[null,"Item","States","Price at January","Price at February","Percentage Change"]
[null,"Apple","Ohio",30,35,{"$f":"(E5-D5)/D5*SIGN(D5)","v":0.16666666666666666}]
[null,"Banana","Utah",20,25,{"$f":"(E6-D6)/D6*SIGN(D6)","v":0.25}]
[null,"Carrots","Nevada",50,45,-0.1]
[null,"Garlic","Ohio",40,35,-0.125]
[null,"Apple","Utah",40,45,0.125]
[null,"Garlic","Nevada",30,25,-0.16666666666666666]
[null,"Carrots","Utah",60,50,-0.16666666666666666]

{"sheet":"SIGN_IFERROR","index":6,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"IF Any Zero or Missing Value is Available",null,null,null,null,null,"Using The SIGN Function Combined with IFERROR Function"]
[]
[null,"Item","Order Date","Price at January","Price at February","Percentage Change",null,"Item","States","Price at January","Price at February","Percentage Change"]
[null,"Apple","2021-04-10",30,35,{"$f":"(E5-D5)/D5*SIGN(D5)","v":0.16666666666666666},null,"Apple","Ohio",30,35,{"$f":"IFERROR((K5-J5)/J5*SIGN(J5),0)","v":0.16666666666666666}]
[null,"Banana","2021-04-25",0,25,{"$f":"(E6-D6)/D6*SIGN(D6)","v":{"$error":"#DIV/0!"}},null,"Banana","Utah",0,25,{"$f":"IFERROR((K6-J6)/J6*SIGN(J6),0)","v":0}]
[null,"Carrots","2021-06-01",null,45,{"$error":"#DIV/0!"},null,"Carrots","Nevada",null,45,0]
[null,"Garlic","2021-06-07",40,35,-0.125,null,"Garlic","Ohio",40,35,-0.125]
[null,"Apple","2021-06-09",40,45,0.125,null,"Apple","Utah",40,45,0.125]
[null,"Garlic","2021-04-10",30,25,-0.16666666666666666,null,"Garlic","Nevada",30,25,-0.16666666666666666]
[null,"Carrots","2021-04-25",60,50,-0.16666666666666666,null,"Carrots","Utah",60,50,-0.16666666666666666]

{"sheet":"SIGN_VLOOKUP","index":7,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Operating The SIGN Function Jointly with The VLOOKUP Function"]
[]
[null,"Sign","Refers to",null,"Item","States","Price at January","Price at February","Change"]
[null,-1,"Down",null,"Apple","Ohio",47,35,{"$f":"VLOOKUP(SIGN(H5-G5),$B$5:$C$7,2)","v":"Down"}]
[null,0,"Equal",null,"Banana","Utah",20,34,{"$f":"VLOOKUP(SIGN(H6-G6),$B$5:$C$7,2)","v":"Up"}]
[null,1,"Up",null,"Carrots","Nevada",50,45,"Down"]
[null,null,null,null,"Garlic","Ohio",40,35,"Down"]
[null,null,null,null,"Apple","Utah",40,45,"Up"]
[null,null,null,null,"Garlic","Nevada",30,25,"Down"]
[null,null,null,null,"Carrots","Utah",60,50,"Down"]

{"sheet":"SIGN_SUMPRODUCT","index":8,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Employing The SIGN Function with The SUMPRODUCT Function"]
[]
[null,"Item","States","Sales",null,"Item","States","Sales"]
[null,"Apple","Ohio",300,null,"Apple","Utah",{"$f":"SUMPRODUCT(--SIGN((B5:B15=\"Apple\")+(C5:C15=\"Utah\")),D5:D15)","v":3160}]
[null,"Banana","Utah",280]
[null,"Carrots","Nevada",500]
[null,"Garlic","Ohio",400]
[null,"Apple","Utah",450]
[null,"Garlic","Nevada",380]
[null,"Carrots","Utah",670]
[null,"Apple","Utah",560]
[null,"Banana","Utah",450]
[null,"Carrots","Nevada",610]
[null,"Apple","Ohio",450]

{"sheet":"SIGN_VBA","index":9,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"The SIGN Function with VBA Code"]
[]
[null,"Number","Output"]
[null,8,1]
[null,0,0]
[null,-8,-1]
[null,0.58779999999999999,1]
[null,-0.58779999999999999,-1]
[null,100000,1]
[null,-100000,-1]