Function options

In this section, we will cover all the function options that are available in the formula property. We will see how they are similar to and different from one another regarding previous constant and operator options for potential combinations.

The function options in the formula property are often specific to a calculation or use case, making them time-consuming to remember and learn. Some of the functions can be replaced by operators in specific circumstances, but the reason learning these functions can be so useful is that they can reduce the length and complexity of the formula while giving you more flexibility at the same time.

Note

The most important thing to remember when learning about the formula property is to look at the type of information it uses and outputs and its syntax in the help window. Many functions can use a variety of inputs and outputs, which can make things confusing.

Once again, we will split the types of functions available into...