Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×