How to display function arguments in Excel
You often use functions in Excel to calculate but there are many less used functions, so you do not remember the argument in the function. You do not need to worry because Excel supports the function's display of arguments so that you can use the function easily.
The following article shows you how to display function arguments in Excel.
Option 1: Select any cell in Excel you enter the syntax = [function name] and press Ctrl + Shift + A , at this time the arguments of the function you enter are displayed in the cell and on the function bar.
For example, if you want to display the arguments of the SUM function, select an Excel cell and enter = SUM and press Ctrl + Shift + A.
Method 2: If you want the number is displayed in more detail, then you enter the syntax = [function name] into any cell and press Ctrl + A .
For example, you want to display the detailed argument of the SUM function, select a cell and enter = SUM then press Ctrl + A.
The Function Arguments dialog box appears, you can enter the value directly for the function arguments if needed and click OK .
The article has shown you two ways to display function arguments in Excel, if you do not remember which function arguments you can display arguments quickly.
Good luck!
You should read it
- AVERAGEIF function - The function returns the average of the arguments with the conditions specified in Excel
- How to use the kernel function (PRODUCT function) in Excel
- COUNT function - Function that counts cells containing numbers in the list of arguments in Excel
- AVERAGEIFS function - The function returns the average of the arguments that meet multiple conditions in Excel
- AVERAGE function - The function returns the average of the arguments in Excel
- How to use ADDRESS function in Excel
- COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel
- COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel
- AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
- Basic Excel functions that anyone must know
- VAR function - The function of estimating variance based on a sample in Excel
- How to use Hlookup function on Excel
Maybe you are interested
How to turn a photo into a painting using the Generative Fill function in Photoshop
How to use the TREND function in Excel
Google Sheets Functions to Simplify Your Budget Spreadsheets
Instructions for using the TRIMRANGE function to clean up Excel tables
How to master numerical data in Google Sheets with the AVERAGE function
Don't buy headphones if they lack this important function!