Logical Functionsis is a small group of functions, seven in all, that allows us to
perform logical operations and test for conditions. e group also includes the IF func-
tion which is useful for producing different answers depending upon different condi-
tions.
Lookup and Reference Functions is group consists of 18 functions that are pri-
marily meant for use in conjunction with lists and tables to locate information. An
example of a function from this group is the VLOOKUP function, which acts somewhat
as an address directory where you look up the address of a person given the name.
Math and Trigonometry Functions
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.