Function Arguments

Use the Function Arguments dialog box to help you insert the correct arguments for your selected function.

Note: The function arguments dialog will adjust depending on the function you select. The following image shows the dialog for the PV (Present Value) function.

The Function Arguments dialog displays the name of the function, a description, and boxes for the arguments.

Function name

The name of the function you are using is displayed at the top of the dialog box.

Argument boxes

The dialog displays boxes for each of the arguments in your selected function. Each argument name is listed along with a box to enter your value or range and the data type expected.

Click the up arrow in any of the argument boxes to hide the argument boxes and display just the formula bar.

Function and argument descriptions

Beneath the argument boxes, you'll see a description of the selected function.

Click in any of the argument boxes to see a description of the purpose of the selected argument. The dialog also displays examples for some arguments.

Formula result

Displays the function result with the argument values you selected in the argument boxes.

Help on this function

Displays the reference help topic in the Help window for the currently selected function.

See Also

Overview of formulas in Excel

How to avoid broken formulas

Detect errors in formulas

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.