NPER function - Microsoft Support
网页This article describes the formula syntax and usage of the NPER function in Microsoft Excel. Description. Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. Syntax. NPER (rate,pmt,pv, [fv], [type])
Overview of formulas in Excel - Microsoft Support
网页If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
SUBTOTAL function - Microsoft Support
网页Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can …
NORM.INV function - Microsoft Support
网页NORM.INV (probability,mean,standard_dev) The NORM.INV function syntax has the following arguments: Probability Required. A probability corresponding to the normal distribution. Mean Required. The arithmetic mean of the distribution. Standard_dev Required. The standard deviation of the distribution.
LOGNORM.DIST function - Microsoft Support
网页Returns the lognormal distribution of x, where ln (x) is normally distributed with parameters Mean and Standard_dev. Use this function to analyze data that has been logarithmically transformed.
NORMINV function - Microsoft Support
网页Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. Note: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage.
Use Excel as your calculator - Microsoft Support
网页Use Excel as your calculator. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula. After you create a formula, you can copy it ...
QUOTIENT function - Microsoft Support
网页This article describes the formula syntax and usage of the QUOTIENT function in Microsoft Excel. Tip: If you want to divide numeric values, you should use the "/" operator as there isn't a DIVIDE function in Excel. For example, to divide 5 by 2, you would type =5/2 into a cell, which returns 2.5.
ROUND function - Microsoft Support
网页The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND (A1, 2) The result of this function is 23.78.
DOLLAR function - Microsoft Support
网页The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the $#,##0.00_); ($#,##0.00) number format, although the currency symbol that is applied depends on your local language settings.
Set page margins before printing a worksheet - Microsoft …
网页To better align an Excel worksheet on a printed page, you can change margins, specify custom margins, or center the worksheet—either horizontally or vertically on the page. Excel for the web. Page margins are the blank spaces …
跳至内容