Class Notes (786,277)
Dr.Hurst (27)
Lecture

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

3 Pages
75 Views

School
McMaster University
Department
Computer Science
Course
COMPSCI 1BA3
Professor
Dr.Hurst
Semester
Fall

Description
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

OR

Don't have an account?

# Join OneClass

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

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.