MIS 24053 Study Guide - Quiz Guide: Lookup Table

• School: Kent State University
• Department: Management and Information Systems
• Course: MIS 24053
• Professor: Geoffrey Steinberg

Document Summary

*if you are setting a range name, that"s a good clue this will be your lookup table. *the lookup value must exist in the first column of the lookup table. *count the number of columns remember to use a column number for the last argument. Value_if_true: operation to be performed if comparison is true. Value_if_false: operation to be performed if comparison is false. *this value by default shows as a debt (negative), add a negative sign in front of the function name to make this positive. Sum, count, max, min, average, median, today, now. =sum(f1:f7), =sum(a1, b3, c5), =sum(a1:b3, c5:e8) mathematical sum. =count(f1:f7), =count(a1, b3, c5), =count(a1:b3, c5:e8) number of values in range. =max(f1:f7), =max(a1, b3, c5), =max(a1:b3, c5:e8) maximum value. =min(f1:f7), =min(a1, b3, c5), =min(a1:b3, c5:e8) minimum value. =average(f1:f7), =average(a1, b3, c5), =average(a1:b3, c5:e8) arithmetic mean. =median(f1:f7), =median(a1, b3, c5), =median(a1:b3, c5:e8) midpoint value.