{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Quick View","Basic","NOT_Omit value","Not Greater Than","NOT OR","NOT AND","NOT IF","NOT ISBLANK","NOT 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":"Quick View","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"NOT Function Excel"]
[]
[null,"Changes FALSE to TRUE, or TRUE to FALSE"]
[null,"=NOT (logical)",null,null,null," "]
[]
[null,"Input","Output","Formula","Explanation"]
[null,true,{"$f":"NOT(TRUE)","v":false},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=NOT(TRUE)"},"Returns the opposite of TRUE"]
[null,false,{"$f":"NOT(FALSE)","v":true},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=NOT(FALSE)"},"Returns the opposite of FALSE"]
[null,0,{"$f":"NOT(0)","v":true},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=NOT(0)"},"Returns TRUE with 0"]
[null,1,{"$f":"NOT(1)","v":false},"=NOT(1)","Returns FALSE with any other number"]
[null,"100<50",{"$f":"NOT(100<50)","v":true},"=NOT(100<50)","Returns the opposite of FALSE"]
[null,"100>50",{"$f":"NOT(100>50)","v":false},"=NOT(100>50)","Reverses TRUE",null," "]
[null,"TV",{"$f":"NOT(B13=\"TV\")","v":false},{"$f":"_xlfn.FORMULATEXT(C13)","v":"=NOT(B13=\"TV\")"},"Reverses TRUE"]
[null,260,{"$f":"NOT(ISNUMBER(B14))","v":false},"=NOT(ISNUMBER(B14))","Reverses TRUE"]
[null,8,{"$f":"NOT(ISODD(B15))","v":true},"=NOT(ISODD(B15))","Reverses FALSE"]

{"sheet":"Basic","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Basic Example of NOT Function"]
[]
[null,"Input","Output","Formula","Explanation"]
[null,true,{"$f":"NOT(TRUE)","v":false},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=NOT(TRUE)"},"Returns the opposite of TRUE"]
[null,false,{"$f":"NOT(FALSE)","v":true},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=NOT(FALSE)"},"Returns the opposite of FALSE"]
[null,0,{"$f":"NOT(0)","v":true},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=NOT(0)"},"Returns TRUE with 0"]
[null,1,{"$f":"NOT(1)","v":false},"=NOT(1)","Returns FALSE with any other number"]
[null,2,{"$f":"NOT(2)","v":false},"=NOT(2)","Returns FALSE with any other number"]
[null,-2,{"$f":"NOT(-2)","v":false},"=NOT(-2)","Returns FALSE with any other number"]
[null,"50=50",{"$f":"NOT(50=50)","v":false},"=NOT(50=50)","Reverses TRUE"]
[null,"100<50",{"$f":"NOT(100<50)","v":true},"=NOT(100<50)","Reverses FALSE"]
[null,"100>50",{"$f":"NOT(100>50)","v":false},"=NOT(100>50)","Reverses TRUE"]
[null,"1+1=2",{"$f":"NOT(1+1=2)","v":false},"=NOT(1+1=2)","Reverses TRUE"]
[null,"2+1=2",{"$f":"NOT(2+1=2)","v":true},"=NOT(2+1=2)","Reverses FALSE"]

{"sheet":"NOT_Omit value","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NOT Function to Omit A Certain Value"]
[]
[null,"Product","Price","Any Product but TV","Formula"]
[null,"TV",500,{"$f":"NOT(B5=\"TV\")","v":false},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=NOT(B5=\"TV\")"}]
[null,"TV",450,{"$f":"NOT(B6=\"TV\")","v":false},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=NOT(B6=\"TV\")"}]
[null,"TV",600,false,"=NOT(B7=\"TV\")"]
[null,"Hard Disk",100,true,"=NOT(B8=\"TV\")"]
[null,"TV",550,false,"=NOT(B9=\"TV\")"]
[null,"Keyboard",30,true,"=NOT(B10=\"TV\")"]
[null,"TV",550,false,"=NOT(B11=\"TV\")"]
[null,"Fan",100,true,"=NOT(B12=\"TV\")"]
[null,"Desktop",270,true,"=NOT(B13=\"TV\")"]
[null,"Monitor",200,true,"=NOT(B14=\"TV\")"]

{"sheet":"Not Greater Than","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NOT for Greater Than or Less Than Value"]
[]
[null,"Product","Price","Not Greater Than?","Formula"]
[null,"TV",500,{"$f":"NOT(C5>200)","v":false},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=NOT(C5>200)"}]
[null,"Desktop",300,{"$f":"NOT(C6>200)","v":false},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=NOT(C6>200)"}]
[null,"Monitor",260,false,"=NOT(C7>200)"]
[null,"Hard Disk",100,true,"=NOT(C8>200)"]
[null,"AC",550,false,"=NOT(C9>200)"]
[null,"Keyboard",30,true,"=NOT(C10>200)"]
[null,"TV",450,false,"=NOT(C11>200)"]
[null,"Fan",100,true,"=NOT(C12>200)"]
[null,"Desktop",270,false,"=NOT(C13>200)"]
[null,"Monitor",200,true,"=NOT(C14>200)"]

{"sheet":"NOT OR","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NOT with OR Function"]
[]
[null,"Product","Price","Any Product but TV and AC","Formula"]
[null,"TV",500,{"$f":"NOT(OR(B5=\"TV\",B5=\"AC\"))","v":false},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=NOT(OR(B5=\"TV\",B5=\"AC\"))"}]
[null,"Desktop",300,{"$f":"NOT(OR(B6=\"TV\",B6=\"AC\"))","v":true},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=NOT(OR(B6=\"TV\",B6=\"AC\"))"}]
[null,"Monitor",260,true,"=NOT(OR(B7=\"TV\",B7=\"AC\"))"]
[null,"Hard Disk",100,true,"=NOT(OR(B8=\"TV\",B8=\"AC\"))"]
[null,"AC",550,false,"=NOT(OR(B9=\"TV\",B9=\"AC\"))"]
[null,"Keyboard",30,true,"=NOT(OR(B10=\"TV\",B10=\"AC\"))"]
[null,"TV",450,false,"=NOT(OR(B11=\"TV\",B11=\"AC\"))"]
[null,"Fan",100,true,"=NOT(OR(B12=\"TV\",B12=\"AC\"))"]
[null,"Desktop",270,true,"=NOT(OR(B13=\"TV\",B13=\"AC\"))"]
[null,"Monitor",200,true,"=NOT(OR(B14=\"TV\",B14=\"AC\"))"]

{"sheet":"NOT AND","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NOT with AND Function "]
[]
[null,"Product","Manufacturer","Exclude TV made by Silo Digital","Formula"]
[null,"TV","Silo Digital",{"$f":"NOT(AND(B5=\"TV\",C5=\"Silo Digital\"))","v":false},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=NOT(AND(B5=\"TV\",C5=\"Silo Digital\"))"}]
[null,"Desktop","Dell",{"$f":"NOT(AND(B6=\"TV\",C6=\"Silo Digital\"))","v":true},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=NOT(AND(B6=\"TV\",C6=\"Silo Digital\"))"}]
[null,"Monitor","Acer",true,"=NOT(AND(B7=\"TV\",C7=\"Silo Digital\"))"]
[null,"Hard Disk","IBM",true,"=NOT(AND(B8=\"TV\",C8=\"Silo Digital\"))"]
[null,"TV","Silo Digital",false,"=NOT(AND(B9=\"TV\",C9=\"Silo Digital\"))"]
[null,"Keyboard","IBM",true,"=NOT(AND(B10=\"TV\",C10=\"Silo Digital\"))"]
[null,"TV","Panasonic",true,"=NOT(AND(B11=\"TV\",C11=\"Silo Digital\"))"]
[null,"Fan","DLB",true,"=NOT(AND(B12=\"TV\",C12=\"Silo Digital\"))"]
[null,"Desktop","IBM",true,"=NOT(AND(B13=\"TV\",C13=\"Silo Digital\"))"]
[null,"TV","Silo Digital",false,"=NOT(AND(B14=\"TV\",C14=\"Silo Digital\"))"]

{"sheet":"NOT IF","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"NOT with IF Function"]
[]
[null,"Product","Price","Don't Buy if TV or AC","Formula"]
[null,"TV",600,{"$f":"IF(NOT(OR((B5=\"TV\"),(B5=\"AC\"))),\"To buy\",\"Don't buy\")","v":"Don't buy"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=IF(NOT(OR((B5=\"TV\"),(B5=\"AC\"))),\"To buy\",\"Don't buy\")"}]
[null,"Desktop",300,{"$f":"IF(NOT(OR((B6=\"TV\"),(B6=\"AC\"))),\"To buy\",\"Don't buy\")","v":"To buy"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=IF(NOT(OR((B6=\"TV\"),(B6=\"AC\"))),\"To buy\",\"Don't buy\")"}]
[null,"Monitor",260,"To buy","=IF(NOT(OR((B7=\"TV\"),(B7=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"Hard Disk",100,"To buy","=IF(NOT(OR((B8=\"TV\"),(B8=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"AC",550,"Don't buy","=IF(NOT(OR((B9=\"TV\"),(B9=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"Keyboard",30,"To buy","=IF(NOT(OR((B10=\"TV\"),(B10=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"TV",450,"Don't buy","=IF(NOT(OR((B11=\"TV\"),(B11=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"Fan",100,"To buy","=IF(NOT(OR((B12=\"TV\"),(B12=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"Desktop",270,"To buy","=IF(NOT(OR((B13=\"TV\"),(B13=\"AC\"))),\"To buy\",\"Don't buy\")"]
[null,"Monitor",200,"To buy","=IF(NOT(OR((B14=\"TV\"),(B14=\"AC\"))),\"To buy\",\"Don't buy\")"]

{"sheet":"NOT ISBLANK","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"NOT with ISBLANK Function (Working with Blank Cells)"]
[]
[null,"Product","Price in July","Price in August","Extra Price","Discount Amount","Formula"]
[null,"TV",500,600,{"$f":"D5-C5","v":100},{"$f":"IF(NOT(ISBLANK(E5)), E5*10%, \"No discount\")","v":10},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=IF(NOT(ISBLANK(E5)), E5*10%, \"No discount\")"}]
[null,"Desktop",300,500,{"$f":"D6-C6","v":200},{"$f":"IF(NOT(ISBLANK(E6)), E6*10%, \"No discount\")","v":20},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=IF(NOT(ISBLANK(E6)), E6*10%, \"No discount\")"}]
[null,"Monitor",260,260,null,"No discount","=IF(NOT(ISBLANK(E7)), E7*10%, \"No discount\")"]
[null,"Hard Disk",100,150,50,5,"=IF(NOT(ISBLANK(E8)), E8*10%, \"No discount\")"]
[null,"AC",450,550,100,10,"=IF(NOT(ISBLANK(E9)), E9*10%, \"No discount\")"]
[null,"Keyboard",30,40,10,1,"=IF(NOT(ISBLANK(E10)), E10*10%, \"No discount\")"]
[null,"TV",450,450,null,"No discount","=IF(NOT(ISBLANK(E11)), E11*10%, \"No discount\")"]
[null,"Fan",100,120,20,2,"=IF(NOT(ISBLANK(E12)), E12*10%, \"No discount\")"]
[null,"Desktop",270,290,20,2,"=IF(NOT(ISBLANK(E13)), E13*10%, \"No discount\")"]
[null,"Monitor",200,200,null,"No discount","=IF(NOT(ISBLANK(E14)), E14*10%, \"No discount\")"]

{"sheet":"NOT VBA","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"NOT Function Using VBA"]
[]
[null,"Data","Numerical Value?","Formula"]
[null,260,{"$f":"NOT(ISNUMBER(B5))","v":false},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=NOT(ISNUMBER(B5))"}]
[null,"Desktop",{"$f":"NOT(ISNUMBER(B6))","v":true},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=NOT(ISNUMBER(B6))"}]
[null,260,{"$f":"NOT(ISNUMBER(B7))","v":false},"=NOT(ISNUMBER(B7))"]
[null,100,{"$f":"NOT(ISNUMBER(B8))","v":false},"=NOT(ISNUMBER(B8))"]
[null,"Keyboard",{"$f":"NOT(ISNUMBER(B9))","v":true},"=NOT(ISNUMBER(B9))"]