Combined formulas

In this section, you will learn how you can combine various formula options into one formula and how you can then nest functions inside one another.

As demonstrated in the previous chapter, you can replace an argument in a formula with anything, including a property, function, constant, or operator. This allows you to create longer formulas such as the one shown in Figure 8.23.

Note

As long as the formula that you create has the same output type in each instance, the formula will work, just as it would with any short function.

The Eisenhower matrix

In Figure 9.1, you can see seven different rows in a database with various input variables from the Priority and Importance properties, which are select properties all giving different outputs in the Formula property from the formula box shown at the bottom of the image.

Figure 9.1 – The Eisenhower matrix formula with the different output variations

The Eisenhower matrix is...