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.