# Using an Excel function as part of another function Using one Excel function as an argument for a second Excel function is an important skill to master. This process can become fairly complex, for example, a Nested-IF statement. Here is a very very simple example of how to go about using the AVERAGE function as the first argument to the ROUND function.

The AVERAGE function takes one argument: a range of cells.

The ROUND function takes two arguments: a number to round off and the number of decimals that the number must be rounded off to. The first argument could be a number, a reference to a cell that contains a number, or a function that returns a number.

In the example below, the first argument of the ROUND function is the AVERAGE function; in other words, the ROUND function is going to “round off” the number returned by the AVERAGE function. The second argument of the ROUND function is the number 0 (the result will have no decimal points).

This simple example sets the scene for more complex calculations, such as Nested IF statements.

This site uses Akismet to reduce spam. Learn how your comment data is processed.