COMPSCI 1BA3 Chapter Notes -Lookup Table
Document Summary
Logical functions such as: if, and, or. These functions determine whether a condition is true or false. True is an approximate match: a lookup column must be in ascending order for true scenarios. False is an exact match: usually a non numerical value such as text but not always, just most of the time, the lookup column does not have to be in ascending order for false scenarios. These operators are used to compare 2 values. Inserting calculated columns in an excel table (pg. 116) When adding a new column to an excel table, the format is generically the same as the other columns. If you enter one formula to a cell of that column, that whole column will automatically have that same formula in each of the cells: same goes for modifying a formula. If you input a formula and you later want to alter it, the altered formula would apply to all the cells within that same column.