import{_ as t}from"./chunks/PageInfo.vue_vue_type_script_setup_true_lang.250b3e56.js";import{_ as a,o as c,c as i,H as n,k as e,a as r,Q as l}from"./chunks/framework.b7580407.js";import"./chunks/commonjsHelpers.725317a4.js";const L=JSON.parse('{"title":"CIS105: Computer Applications & Information Systems Lect. 6 Pt. 2","description":"","frontmatter":{},"headers":[],"relativePath":"academic/cis105/cis105-l6-pt2-lecture-note.md","filePath":"academic/cis105/cis105-l6-pt2-lecture-note.md","lastUpdated":1710267506000}'),d={name:"academic/cis105/cis105-l6-pt2-lecture-note.md"},s=e("h1",{id:"cis105-computer-applications-information-systems-lect-6-pt-2",tabindex:"-1"},[r("CIS105: Computer Applications & Information Systems Lect. 6 Pt. 2 "),e("a",{class:"header-anchor",href:"#cis105-computer-applications-information-systems-lect-6-pt-2","aria-label":'Permalink to "CIS105: Computer Applications & Information Systems Lect. 6 Pt. 2"'},"​")],-1),u=l('<h2 id="chapter-6-logical-functions" tabindex="-1">Chapter 6: Logical Functions <a class="header-anchor" href="#chapter-6-logical-functions" aria-label="Permalink to &quot;Chapter 6: Logical Functions&quot;">​</a></h2><h3 id="_6-1-new-functions" tabindex="-1">6.1: New Functions <a class="header-anchor" href="#_6-1-new-functions" aria-label="Permalink to &quot;6.1: New Functions&quot;">​</a></h3><ul><li><p><code>AND</code>: Checks whether all arguments are <code>TRUE</code>, and returns <code>TRUE</code> if all arguments are <code>TRUE</code>.</p></li><li><p><code>OR</code>: Checks whether any of the arguments are <code>TRUE</code>, and returns <code>TRUE</code> or <code>FALSE</code>.</p></li><li><p><code>NOT</code>: Changes <code>TRUE</code> to <code>FALSE</code>, or <code>FALSE</code> to <code>TRUE</code>.</p></li><li><p><code>IF</code>: Checks whether a condition is met, and returns one value if <code>TRUE</code>, and another value if <code>FALSE</code>.</p><ul><li>Nested <code>IF</code>: Using multiple <code>IF</code> statements in one functions to account for multiple conditions.</li></ul></li><li><p><code>VLOOKUP</code>: Looks for a value in a table or a range veryically</p><ul><li><code>VLOOKUP</code> What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an approximate or exact match: Indicates as <code>1/TRUE</code>, or <code>0/FALSE</code>.</li></ul></li><li><p><code>HLOOKUP</code>: Looks for a value in a table or a range horizontally.</p></li><li><p><code>COUNTIF</code>: Counts the number of cells within a range that meet the given condition.</p><ul><li><code>=COUNTIF(Where do you want to look? What do you want to look for?)</code></li></ul></li><li><p><code>SUMIF</code>: Adds the cells specified by a given condition or criteria.</p></li><li><p><code>AVERAGEIF</code>: s an Excel Statistical function, which calculates the average of a given range of cells by a specific criterion.</p></li></ul><h3 id="_6-2-comparison-operators" tabindex="-1">6.2: Comparison Operators <a class="header-anchor" href="#_6-2-comparison-operators" aria-label="Permalink to &quot;6.2: Comparison Operators&quot;">​</a></h3><ul><li><code>&gt;</code>: More than</li><li><code>&lt;</code>: Less than</li><li><code>&gt;=</code>: More than or equal to</li><li><code>&lt;=</code>: Less that or equal to</li></ul><h3 id="_6-3-reminder" tabindex="-1">6.3: Reminder <a class="header-anchor" href="#_6-3-reminder" aria-label="Permalink to &quot;6.3: Reminder&quot;">​</a></h3><ul><li><strong>Excel does not recognize tex</strong><ul><li>When searching for keywords, put keyword between <code>&quot;&quot;</code> delimiters.</li></ul></li></ul>',7);function p(h,m,f,_,g,E){const o=t;return c(),i("div",null,[s,n(o,{readTime:"1",words:"249"}),u])}const w=a(d,[["render",p]]);export{L as __pageData,w as default};
