Microsoft Excel functions banner image.

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).

Using a function as an argument for a function in Excel.
Using a function as an argument for a function in Excel.

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

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published. Required fields are marked *

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