Introduction to Game Systems Design

Chapter 6

Spreadsheet Functions

Spreadsheets can calculate more than simple formulas; they can use functions, which are prewritten bits of code, each of which does a specific task. End users, including game system designers, use functions to quickly perform complex tasks without needing to know exactly what the underlying code does. Every function has a function name and parameters. The function is what should happen, and the parameters accept bits of data called arguments and tell the function what data to use as it performs the function.

Grouping Arguments

Computer programs do not know English intuitively as humans do, so you must write functions and input data in a format that the computer can understand without any ambiguity.

For example, ...