CIS 105 Lecture 6: Wood- Lessons #3 &4

• School: ASU
• Department: Computer Information Systems
• Course: CIS 105
• Professor: Mc Carthy Matthew

Document Summary

Boolean functions: no quotation marks around true or false. Or(a,b,c) true if any one is true: and(a,b,c ) true only if all are true, not reverses everything. Three arguments separated by commas: =if(condition, result if condition met or true, result if condition not met or false) Four arguments separated by commas: =vlookup(1,2,3,4, what you are looking up, the table in which it can be found, the column with the answer, matches how. What you are looking up is usually a cell address: table is a range don"t include headers in the range use absolute address for the range so you can copy it. Using nested if"s: n-1 if"s for n different levels or values to which you are comparing, put levels or values in descending or ascending order, consider graduated commission rate dependent on volume of sales, =if(sales>10,2%,if(sales>5,1%,0)) Can use nested if"s and vlookup for the same problem.