Class Notes (786,277)
Canada (482,090)
Dr.Hurst (27)

Notesolutions COMP SCI 1B03 Lecture 4A.docx
Notesolutions COMP SCI 1B03 Lecture 4A.docx

3 Pages
Unlock Document

McMaster University
Computer Science

September 20, 2012 Lookup Tables and Functions - What is a lookup Table? - A table that organizes data you want to retrieve into different categories - The categories for the lookup table, called compare values, are located in the table's first column or row - To retrieve a particular value from the table, a lookup value (the value you are trying to find) needs to match the compare values - Using the lookup table to find an exact match  VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) - Using the lookup table to find an approximate match - Searches the first column of the table until it locates the largest value that is less than the lookup value IFERROR Function - Error values such as #DIV/0!, #N/A, and #VALUE! indicate that some element in a formula or a cell referenced in a formula is preventing Excel from returning a calculated value - The IFERROR function can determine if a cell contains an error value and display the message you choose rather than the default error value - What is it? - Allows you to change a cell's formatting when its contents match a specified condition. - When would you use this? - To highlight those cells whose values may warrant action - E.g., duplicate records, negative balances, overdue dates Conditional Formatting - Rules Manager - A rule specifies the type of condition (such as formatting cells greater than a specified value), the type of formatting when that condition occurs Summarizing Data Conditionally - You can calculate the number of cells in a range that match cirteia you specify using the COUNTIF function, which is sometimes referred to as a conditional count - Syntax: =COUNTIF(range, criteria) - You can add the values in a range that meet criteria you specify using the SUMIF function, which is also called a conditional sum - Syntax: =SUMIF(range, criteria[,sum_range]) - You can use the A
More Less

Related notes for COMPSCI 1BA3

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.