{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Example","Arguments","Logical operators","Excel functions","blank","not blank","error","istext","isnumber","false do nothing","greater than","smaller than","equals","multiple values","not equal","begins with","ends with","contains","contains any text","exact match","AND logic","sheets","copy","keep value","keep blank","cell color","between two numbers","by date"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"Example","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"=IF(logical_test, [value_if_true], [value_if_false])",null,null,null,null,"Website: ","Get Digital Help"]
[null,null,null,null,null,null,"Webpage:","How to use the IF function"]
[null,"Value","IF function","Formula"]
[null,5,{"$f":"IF(B5=5,\"Equal to 5\",\"Not equal to 5\")","v":"Equal to 5"},{"$f":"[1]!ShowFormula(C5)","v":"=IF(B5=5,\"Equal to 5\",\"Not equal to 5\")"}]
[null,3,{"$f":"IF(B6=5,\"Equal to 5\",\"Not equal to 5\")","v":"Not equal to 5"},{"$f":"[1]!ShowFormula(C6)","v":"=IF(B6=5,\"Equal to 5\",\"Not equal to 5\")"}]
[null,6,"Not equal to 5",{"$f":"[1]!ShowFormula(C7)","v":"=IF(B7=5,\"Equal to 5\",\"Not equal to 5\")"}]
[null,2,"Not equal to 5",{"$f":"[1]!ShowFormula(C8)","v":"=IF(B8=5,\"Equal to 5\",\"Not equal to 5\")"}]
[null,5,{"$f":"IF(B9=5,\"Equal to 5\",)","v":"Equal to 5"},{"$f":"[1]!ShowFormula(C9)","v":"=IF(B9=5,\"Equal to 5\",)"}]
[null,5,{"$f":"IF(B10=5,\"Equal to 5\")","v":"Equal to 5"},{"$f":"[1]!ShowFormula(C10)","v":"=IF(B10=5,\"Equal to 5\")"}]
[null,3,{"$f":"IF(B11=5,)","v":false},{"$f":"[1]!ShowFormula(C11)","v":"=IF(B11=5,)"}]
[null,5,{"$f":"IF(B12=5,)","v":0},{"$f":"[1]!ShowFormula(C12)","v":"=IF(B12=5,)"}]

{"sheet":"Arguments","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"IF function","Formula",null,null,"Website: ","Get Digital Help"]
[null,{"$f":"IF(10/20,\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(B3)","v":"=IF(10/20,\"TRUE\",\"FALSE\")"},null,null,"Webpage:","How to use the IF function"]
[null,{"$f":"IF(0,\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(B4)","v":"=IF(0,\"TRUE\",\"FALSE\")"}]
[null,{"$f":"IF(1,\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(B5)","v":"=IF(1,\"TRUE\",\"FALSE\")"}]
[null,{"$f":"IF(-1,\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(B6)","v":"=IF(-1,\"TRUE\",\"FALSE\")"}]

{"sheet":"Logical operators","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","IF function","Formula",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3=5,\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(C3)","v":"=IF(B3=5,\"TRUE\",\"FALSE\")"},null,null,"Webpage:","How to use the IF function"]
[null,3,{"$f":"IF(B4>5,\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(C4)","v":"=IF(B4>5,\"TRUE\",\"FALSE\")"}]
[null,6,{"$f":"IF(B5<5,\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(C5)","v":"=IF(B5<5,\"TRUE\",\"FALSE\")"}]
[null,2,{"$f":"IF(B6<=5,\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(C6)","v":"=IF(B6<=5,\"TRUE\",\"FALSE\")"}]
[null,5,{"$f":"IF(B7>=5,\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(C7)","v":"=IF(B7>=5,\"TRUE\",\"FALSE\")"}]
[null,5,{"$f":"IF(B8<>5,\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(C8)","v":"=IF(B8<>5,\"TRUE\",\"FALSE\")"}]

{"sheet":"Excel functions","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","IF function","Formula",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(ISBLANK(B3),\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(C3)","v":"=IF(ISBLANK(B3),\"TRUE\",\"FALSE\")"},null,null,"Webpage:","How to use the IF function"]
[null,null,{"$f":"IF(ISBLANK(B4),\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(C4)","v":"=IF(ISBLANK(B4),\"TRUE\",\"FALSE\")"}]
[null,6,{"$f":"IF(ISNUMBER(B5),\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(C5)","v":"=IF(ISNUMBER(B5),\"TRUE\",\"FALSE\")"}]
[null,"A",{"$f":"IF(ISNUMBER(B6),\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(C6)","v":"=IF(ISNUMBER(B6),\"TRUE\",\"FALSE\")"}]
[null,5,{"$f":"IF(_xlfn.ISFORMULA(B7),\"TRUE\",\"FALSE\")","v":"FALSE"},{"$f":"[1]!ShowFormula(C7)","v":"=IF(ISFORMULA(B7),\"TRUE\",\"FALSE\")"}]
[null,{"$f":"5+1","v":6},{"$f":"IF(_xlfn.ISFORMULA(B8),\"TRUE\",\"FALSE\")","v":"TRUE"},{"$f":"[1]!ShowFormula(C8)","v":"=IF(ISFORMULA(B8),\"TRUE\",\"FALSE\")"}]
[]
[null,null,"=5+1"]

{"sheet":"blank","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Check if blank",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3=\"\",\"Blank\",B3)","v":5},null,null,"Webpage:","How to use the IF function"]
[null,null,{"$f":"IF(B4=\"\",\"Blank\",B4)","v":"Blank"}]
[null,6,6]
[null,2,2]
[null,null,"Blank"]
[null,5,5]
[null,null,"Blank"]
[null,5,5]

{"sheet":"not blank","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Check if blank",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3<>\"\",B3,\"Blank\")","v":5},null,null,"Webpage:","How to use the IF function"]
[null,null,{"$f":"IF(B4<>\"\",B4,\"Blank\")","v":"Blank"}]
[null,6,6]
[null,2,2]
[null,null,"Blank"]
[null,5,5]
[null,null,"Blank"]
[null,5,5]

{"sheet":"error","index":6,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Check errors",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(ISERROR(B3),\"Error\",B3)","v":5},null,null,"Webpage:","How to use the IF function"]
[null,4,{"$f":"IF(ISERROR(B4),\"Error\",B4)","v":4}]
[null,{"$f":"1/0","v":{"$error":"#DIV/0!"}},"Error"]
[null,2,2]
[null,7,7]
[null,{"$f":"IFF","v":{"$error":"#NAME?"}},"Error"]
[null,9,9]
[null,5,5]

{"sheet":"istext","index":7,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Check errors",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(ISTEXT(B3),\"Text\",\"Not text\")","v":"Not text"},null,null,"Webpage:","How to use the IF function"]
[null,"A",{"$f":"IF(ISTEXT(B4),\"Text\",\"Not text\")","v":"Text"}]
[null,{"$f":"1/0","v":{"$error":"#DIV/0!"}},"Not text"]

{"sheet":"isnumber","index":8,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Check errors",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(ISNUMBER(B3),\"Number\",\"Not number\")","v":"Number"},null,null,"Webpage:","How to use the IF function"]
[null,"A",{"$f":"IF(ISNUMBER(B4),\"Number\",\"Not number\")","v":"Not number"}]
[null,{"$f":"1/0","v":{"$error":"#DIV/0!"}},"Not number"]

{"sheet":"false do nothing","index":9,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Check errors",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3=5,B3+5,\"\")","v":10},null,null,"Webpage:","How to use the IF function"]
[null,4,{"$f":"IF(B4=5,B4+5,\"\")","v":""}]
[null,6,""]

{"sheet":"greater than","index":10,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","greater than?",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3>$C$7,B3,\"\")","v":""},null,null,"Webpage:","How to use the IF function"]
[null,4,{"$f":"IF(B4>$C$7,B4,\"\")","v":""}]
[null,6,6]
[]
[null,"Greater than:",5]

{"sheet":"smaller than","index":11,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Smaller than?",null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3<$C$7,B3,\"\")","v":""},null,null,"Webpage:","How to use the IF function"]
[null,4,{"$f":"IF(B4<$C$7,B4,\"\")","v":4}]
[null,6,""]
[]
[null,"Smaller than:",5]

{"sheet":"equals","index":12,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Equal",null,null,null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3=$C$7,\"Yes\",\"No\")","v":"No"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,4,{"$f":"IF(B4=$C$7,\"Yes\",\"No\")","v":"Yes"}]
[null,6,"No"]
[]
[null,"Value:",4]

{"sheet":"multiple values","index":13,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Equal",null,null,null,null,"Website: ","Get Digital Help"]
[null,"A",{"$f":"IF(OR(B3=$C$9:$C$11),\"Yes\",\"No\")","v":"No"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,"D",{"$f":"IF(OR(B4=$C$9:$C$11),\"Yes\",\"No\")","v":"Yes"}]
[null,"C",{"$f":"IF(OR(B5=$C$9:$C$11),\"Yes\",\"No\")","v":"Yes"}]
[null,"B",{"$f":"IF(OR(B6=$C$9:$C$11),\"Yes\",\"No\")","v":"No"}]
[null,"F",{"$f":"IF(OR(B7=$C$9:$C$11),\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Value:","D"]
[null,null,"C"]
[null,null,"F"]

{"sheet":"not equal","index":14,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","not equal",null,null,null,null,"Website: ","Get Digital Help"]
[null,5,{"$f":"IF(B3<>$C$7,\"Yes\",\"No\")","v":"Yes"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,4,{"$f":"IF(B4<>$C$7,\"Yes\",\"No\")","v":"No"}]
[null,6,"Yes"]
[]
[null,"Value:",4]

{"sheet":"begins with","index":15,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","begins with",null,null,null,null,"Website: ","Get Digital Help"]
[null,"Red",{"$f":"IF(LEFT(B3,LEN($C$7))=$C$7,\"Yes\",\"No\")","v":"No"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,"Blue",{"$f":"IF(LEFT(B4,LEN($C$7))=$C$7,\"Yes\",\"No\")","v":"No"}]
[null,"Green","Yes"]
[]
[null,"Begins with:","Gr"]

{"sheet":"ends with","index":16,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","begins with",null,null,null,null,"Website: ","Get Digital Help"]
[null,"Red",{"$f":"IF(RIGHT(B3,LEN($C$7))=$C$7,\"Yes\",\"No\")","v":"No"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,"Blue",{"$f":"IF(RIGHT(B4,LEN($C$7))=$C$7,\"Yes\",\"No\")","v":"Yes"}]
[null,"Green","No"]
[]
[null,"Ends with:","ue"]

{"sheet":"contains","index":17,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","begins with",null,null,null,null,"Website: ","Get Digital Help"]
[null,"Red",{"$f":"IF(COUNTIF(B3,\"*\"&$C$7&\"*\"),\"Yes\",\"No\")","v":"Yes"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,"Blue",{"$f":"IF(COUNTIF(B4,\"*\"&$C$7&\"*\"),\"Yes\",\"No\")","v":"No"}]
[null,"Green","Yes"]
[]
[null,"Contains:","r"]

{"sheet":"contains any text","index":18,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","begins with",null,null,null,null,"Website: ","Get Digital Help"]
[null,23145256,{"$f":"IF(ISERROR(B3*1),\"Contains text\", \"No text\")","v":"No text"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,"875A6325",{"$f":"IF(ISERROR(B4*1),\"Contains text\", \"No text\")","v":"Contains text"}]
[null,6.4,"No text"]

{"sheet":"exact match","index":19,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Value","Case sensitive",null,null,null,null,"Website: ","Get Digital Help"]
[null,"France",{"$f":"IF(EXACT(B3,$C$11),\"Yes\",\"No\")","v":"No"},null,null,null,null,"Webpage:","How to use the IF function"]
[null,"france",{"$f":"IF(EXACT(B4,$C$11),\"Yes\",\"No\")","v":"No"}]
[null,"frAnce","No"]
[null,"FranCe","No"]
[null,"FrancE","Yes"]
[null,"France","No"]
[null,"FraNce","No"]
[]
[null,"Exact match:","FrancE"]

{"sheet":"AND logic","index":20,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Text:","Qty:","Match both?",null,null,null,"Website: ","Get Digital Help"]
[null,"Blue",5,{"$f":"IF(AND(B3=$C$11,C3=$C$12),\"Yes\",\"No\")","v":"No"},null,null,null,"Webpage:","How to use the IF function"]
[null,"Red",3,{"$f":"IF(AND(B4=$C$11,C4=$C$12),\"Yes\",\"No\")","v":"No"}]
[null,"Green",8,"Yes"]
[null,"Brown",6,"No"]
[null,"White",9,"No"]
[null,"Black",2,"No"]
[null,"Yellow",4,"No"]
[]
[null,"Text:","Green"]
[null,"Qty:",8]

{"sheet":"sheets","index":21,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Text:","Worksheets:",null,null,null,"Website: ","Get Digital Help"]
[null,"Blue",{"$f":"IF(B3='AND logic'!B3,\"Yes\",\"No\")","v":"Yes"},null,null,null,"Webpage:","How to use the IF function"]
[null,"White",{"$f":"IF(B4='AND logic'!B4,\"Yes\",\"No\")","v":"No"}]
[null,"Green",{"$f":"IF(B5='AND logic'!B5,\"Yes\",\"No\")","v":"Yes"}]

{"sheet":"copy","index":22,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Qty","Formula",null,null,null,"Website: ","Get Digital Help"]
[null,4,{"$f":"IF(B3=5,B3+$C$7,\"\")","v":""},null,null,null,"Webpage:","How to use the IF function"]
[null,5,{"$f":"IF(B4=5,B4+$C$7,\"\")","v":10}]
[null,6,""]
[]
[null,"Add value:",5]

{"sheet":"keep value","index":23,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Qty","Formula",null,null,null,"Website: ","Get Digital Help"]
[null,4,{"$f":"IF(B3=5,B3,\"\")","v":""},null,null,null,"Webpage:","How to use the IF function"]
[null,5,{"$f":"IF(B4=5,B4,\"\")","v":5}]
[null,6,""]
[]
[null,"Keep value:",5]

{"sheet":"keep blank","index":24,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Qty","Formula",null,null,null,"Website: ","Get Digital Help"]
[null,4,{"$f":"IF(B3=\"\",\"\",B3+$C$7)","v":9},null,null,null,"Webpage:","How to use the IF function"]
[null,null,{"$f":"IF(B4=\"\",\"\",B4+$C$7)","v":""}]
[null,6,11]
[]
[null,"Add:",5]

{"sheet":"cell color","index":25,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Qty","Formula",null,null,null,"Website: ","Get Digital Help"]
[null,4,{"$f":"IF(Color=6,B3+$C$7,B3)","v":9},null,null,null,"Webpage:","How to use the IF function"]
[null,5,{"$f":"IF(Color=6,B4+$C$7,B4)","v":5}]
[null,6,{"$f":"IF(Color=6,B5+$C$7,B5)","v":11}]
[]
[null,"Add:",5]

{"sheet":"between two numbers","index":26,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"id","Qty","Formula",null,null,"Website: ","Get Digital Help"]
[null,4,9,{"$f":"IF((B3>=$C$8)*(B3<=$C$9),C3,\"\")","v":""},null,null,"Webpage:","How to use the IF function"]
[null,5,27,{"$f":"IF((B4>=$C$8)*(B4<=$C$9),C4,\"\")","v":27}]
[null,6,15,15]
[null,7,19,""]
[]
[null,"Start:",5]
[null,"End:",6]

{"sheet":"by date","index":27,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Qty","Formula",null,null,"Website: ","Get Digital Help"]
[null,44872,9,{"$f":"IF(B3=$C$8,C3,\"\")","v":""},null,null,"Webpage:","How to use the IF function"]
[null,"2022-11-08",27,{"$f":"IF(B4=$C$8,C4,\"\")","v":""}]
[null,"2022-11-09",15,15]
[null,"2022-11-10",19,""]
[]
[null,"Date:",44874]