Study Guides (248,410)
United States (123,379)
Boston College (3,492)
ISYS 1021 (10)
Final

Notes for Final.pdf

1 Page
177 Views
Unlock Document

Department
Information Systems
Course
ISYS 1021
Professor
Craig Brown
Semester
Fall

Description
SUMIF(range,criteria, sum_range) | COUNTIF(range,criteria) | In SUMIF/COUNTIF even algebraic Logical tests must be contained in “ ” VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Using Vlookup to find max: B C D E 19 Last Name First Name Final Last Name 20 kfjhe krhxkwhru 95 kfjhe =VLOOKUP(MAX(D20:D24);D20:E24;2;FALSE) 21 wwrefw okpomp 45 wwrefw 22 sdq pmoij 72 sdq 23 vbdgds iuyewro 68 vbdgds 24 mpjp qsdwqef 45 mpjp ROUND(number, num_digits) | TRUNC(number, num_digits ) | INT(-4.5) = -5 BUT TRUNC(-4.5) = -4 | Logical Tests =IF(logical_test,true_val.,false_val) | Lo
More Less

Related notes for ISYS 1021

Log In


OR

Join OneClass

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

Sign up

Join to view


OR

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.


Submit