You can see the below example which uses three arguments. As there are multiple arguments, they are separated by commas in between them. Here, ( A1: A6, B1: B6) are the arguments for AVERAGE and SUM functions. You can either use the single argument with range or you can use two arguments where you can define the two ranges separately like, =AVERAGE(A1:A6,B1:B6) & =SUM(A1:A6,B1:B6). Suppose you want to calculate the average and sum of two columns. If you want to use multiple arguments in a function you need to use coma in between them. Read More: How to Use the Select Case Structure in Excel VBA Functions with Multiple Arguments Here the argument is a text-string placed in cell A1. It accepts a single argument as input and converts the lower case letter into the uppercase letter. Here we used the function UPPER which takes text-string as an argument.
Below is an example of a function with a single argument. Further Readings: Functions with a Single ArgumentĪrguments are mostly referred to individual cells but it also includes cell ranges.
