In addition to entering formulas that perform basic math — such as adding, subtracting, multiplying, and dividing — you can use a vast library of built-in worksheet functions in Microsoft Excel to do much more.
You can use these functions to return information, such as:
- Getting the current date.
- Finding the number of characters in a cell.
- Manipulating text; for example, converting "hello" to "Hello" or even "HELLO."
- Calculating a loan payment.
- Testing the contents of two cells to see which is larger or if they are identical.
Start typing in a cell
- In a cell, type the equal sign (=) and then type a letter, such as "a," to see a list of available functions.
- Use the down arrow key to scroll down through the list.
As you scroll through the list, you'll see a ScreenTip (a brief description) for each function. For example, the ScreenTip for the ABS function is "Returns the absolute value of a number, a number without its sign."
Choose a function and fill in its arguments
- In the list, double-click the function that you want to use. Excel enters the function name in the cell, followed by an opening parenthesis; for example, =SUM(.
Enter one or more arguments after the opening parenthesis, if necessary. An argument is a piece of information that the function uses. Excel shows you what type of information you should enter as an argument. Sometimes it's a number, sometimes it's text, and sometimes it's a reference to another cell.
For example, the ABS function requires one number as its argument. The UPPER function (which converts any lowercase text to uppercase text) requires one string of text as its argument. The PI function requires no arguments, because it simply returns the value of pi (3.14159...).
Complete the formula and see the results
Excel adds the closing parenthesis for you, and the cell shows the result of the function that you used in the formula. Select the cell and look at the formula bar to view the formula.
- Watch a video to see how to use functions: Video: Use functions in formulas
- Try creating formulas that use nested functions; that is, a formula that uses one function and then uses the result of that in another function.
- Try using some functions that you've never used before and see if they return the values you expect.
Top of Page