With multiple cells selected, this shortcut will enter the same data in all cells in the selection at once. This is a great way to skip a copy & paste step. Cells do not need to be contiguous; use Control (Win) or Command (Mac) to select non-contiguous cells before using Control + Enter.
Let's take a look at how to enter values into an Excel worksheet.
Negative values. If you need to add a negative value, enter a minus (-) sign before the value. You can also put in parentheses if you want. Excel will convert it to negative if you choose to use parentheses.
Dollar amounts. If you're entering a value that's a dollar amount, you can add dollar signs and commas just like you would if you were writing it by hand.
Decimal points. If you need to add a decimal point, use the period key on your keyboard.
Fractions. If you need to convert a fraction to a decimal, Excel can do that for you, so there's no need to stress over it yourself. Simply type the fraction in using the slash key on the keyboard. Just make sure you leave a space after any whole numbers before typing in the fraction, as shown below.
![Sql Sql](/uploads/1/2/5/8/125854930/192834110.jpg)
![How to enter values in spss How to enter values in spss](/uploads/1/2/5/8/125854930/170924552.png)
Hit Enter on your keyboard.
As you can see below, Excel classified the number as a value and aligned it to the left. However, it's still a fraction.
Click on the cell that contains the fraction, then take look at the Formula Bar.
Excel converted it to a decimal.
This Excel tutorial explains how to use the Excel LINEST function with syntax and examples.
Description
The Microsoft Excel LINEST function uses the least squares method to calculate the statistics for a straight line and returns an array describing that line.
The LINEST function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LINEST function can be entered as part of a formula in a cell of a worksheet.
The LINEST function uses the following line equation:
Syntax
The syntax for the LINEST function in Microsoft Excel is:
Parameters or Arguments
- y_values
- The known set of 'y values' from the line equation.
- x_values
- Optional. It is the known set of 'x values' from the line equation. If this parameter is omitted, x_values is assumed to be {1,2,3,...} with the same number of values as y_values.
- constant
- Optional. It is either TRUE or FALSE. If this parameter is omitted, the function will assume TRUE. If constant is TRUE, b in the line equation is calculated normally. If constant is FALSE, b becomes 0 so that the line equation is evalulated as y = mx.
- additional_statistics
- Optional. It is either TRUE or FALSE. If this parameter is omitted, the function will assume FALSE. If additional_statistics is TRUE, the function will return additional regression statistics. If additional_statistics is FALSE, the function will returns only m coefficients and b constant.
Returns
The LINEST function returns a numeric value.
Applies To
- Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Example (as Worksheet Function)
Let's look at some Excel LINEST function examples and explore how to use the LINEST function as a worksheet function in Microsoft Excel:
This first example we have entered the y values in column A (cells A2 through A6) and the x values in column B (cells B2 through B6). Then we have entered the following LINEST function in both cells D2 and E2 as follows:
The LINEST function can be written as an array formula. When creating your array formula, you need to do the following:
- Enter the formulas in both cells D2 and E2
- Highlight cells D2 and E2
- Press F2 (in Windows) or CONTROL+U (on Mac)
- Press Ctrl+Shift+Enter
This creates {} brackets around your formulas as follows:
You can see how the formula look in the images below.
The value in cell D2 returns the slope of 0.5 and the value in cell E2 returns the y-intercept of 0.
This formula could also be written as follows (entering values instead of cell ranges):
The LINEST function can be written as an array formula. When creating your array formula, you need to do the following:
- Enter the formulas in both cells D2 and E2
- Highlight cells D2 and E2
- Press F2 (in Windows) or CONTROL+U (on Mac)
- Press Ctrl+Shift+Enter
This creates {} brackets around your formulas as follows: