You've probably noticed that functions use parentheses, and inside those parentheses are certain inputs. These inputs have a special name: arguments.
Let's look at some examples.
Arguments can be required or optional. Some functions take three or more arguments, and some functions don't take any arguments at all.
A good example of a function that takes no arguments is the TODAY function, which returns the current date. To use it, just enter an equal sign, TODAY, and empty parentheses.
Other functions take multiple arguments; all of which are required. A good example is the DATE function, which allows you to build a valid date using the year, month, and day supplied as separate and required arguments.
Note that as you enter a function that Excel recognizes, Excel will display a tip window with information on all arguments.
The current argument will be displayed in bold text. Each additional argument must be separated with a comma. As you enter arguments and commas, you'll see each argument bolded in turn.
Note that Excel doesn't care whether commas are followed by spaces or not.
Some functions have optional arguments, which are shown in square brackets inside the formula tip window.
An example of a function that takes an optional argument is the ROW function. Without any arguments, ROW returns the row of the cell it's located in. However, if you supply a reference, ROW returns the row number of that reference. For example, if we supply H10 as the reference, ROW returns the number 10.
Some functions can take a large number of optional arguments. A good example is the SUM function. The concept of additional optional arguments is expressed with ellipses, which appear at the end of the argument list when a function takes multiple optional arguments.
The SUM function can actually accept up to 256 arguments total. By using commas to separate arguments, we can easily sum the contents of many cells at the same time. A little trick you can use with the SUM function is to hold down the Control key as you select additional cells. Excel will then add the commas for you.
In many cases, you won't supply arguments as hard-coded values, since that defeats the power of a spreadsheet. Instead, you'll supply values that come from other cells.
As an example, the EDATE function takes two arguments: a start date, and months, and then returns the same date in the future or past.
When you expose arguments as cells on the worksheet, you can supply cell references as arguments. This allows you to easily change the input values later, and get a different result from the function.
The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY with a date number...
The Excel DATE function creates a valid date from individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.
The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.
The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.
The Excel EDATE function returns a date on the same day of the month, n months in the past or future. You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the...