CHEM 1030 Lecture Notes - Lecture 10: Social Security Number, Calendar Date, Hello, Goodbye

• School: Auburn University
• Department: Chemistry
• Course: CHEM 1030
• Professor: Ria Yngard

Document Summary

Cis105 - lecture 10 - date, time & text functions (wood switching days with mccarthy) No quotation marks around true or false. Boolean functions are already coded to answer these. Not ok - if(c1= true , hello , goodbye ) Or(a,b,c ) - true if any one is true. And(a,b,c ) - true only if all are true. Given a1 is true, b1 is true, c1 is false, evaluate. Results if condition not met or false) The table in which it can be found. The column (or row) with the answer. Using 3 arguments in the hookup function looks like the following: False - exact match in column (or row)1 - used when looking up a name or a non-calculating number such as a social security. True - column 1 is in ascending order and match is to row (or column) closest but not greater than - used when translating a score or numeric value into a group or category.