What's got half a million words? The Lord of the Rings trilogy. And
our new formula and property documentation, which is now on the web.
Thousands of formula examples make getting started with all the new
features easy.
Use the IF function with multiple conditions without having to use
more than two parentheses. Use SWITCH when you need to test the same
value for equality against other values.
CSV files produced by report buttons can now be customized to make
them compatible with more apps and services. Change the decimal
separator and the delimiter separating values and lay out values
vertically instead of horizontally.
If a function isn't returning the value you expect, you need to look
at the parameters it receives by creating new temporary fields
visualizing the parameters. To do so with an array, you need to
convert it to a text string first using the TEXTJOIN function.
Ranges are an effective means of creating arrays containing many
elements. However, it is easy to lose track of what elements they
contain, which can have surprising results. This tip explores this
topic in depth.