BISM1201 Study Guide - Final Guide: El Nombre, Lookup Table

• School: UQ
• Department: Business Information Systems
• Course: BISM1201
• Professor: Peter Clutterbuck

Document Summary

Excel (lecture 5 12: if function. Is a decision-making function that allows us to automate our workbooks to make decisions or choices. Is a member of the logical function category in excel. This category only comprises: if, or, and, iferror, not, false, true. Syntax of if function is: if(logical_test, [value_if_true], [value_if_false]) The argument logical_test is any value or expression that can be evaluated to true or false. For example, a10=100 is a logical expression; if the value in cell a10 is equal to 100, the expression evaluates to true. Or = only 1 argument has to be true. The difference between vertical and horizontal lookup is how the lookup table is structured. Hlookup uses a lookup table structured as rows (and vlookup as columns). Argument: a value that provides information to an action, an event, a method, a property, a function or a procedure.