Learn

Creating a Product validation rule

Using DGET to return a single value

Using DGET to return a single value   Figure 10.26 – Formulating the DGET database function Figure 10.27 – Creating a Product validation rule Let’s look at a few more examples of database functions. Constructing DAVERAGE We will now work out the average gross margin: Figure 10.28 – Formula construction for the average gross margin […]

Using DGET to return a single value Read More »

Exploring database functions

Exploring database functions There are twelve database functions in Excel that cover most of the clusters of functions. These functions have been in the Excel library for many years, and are often forgotten about or not known, as there are so many other functions we can use today. Database functions are a substitute for IFS

Exploring database functions Read More »

Share knowledge