Round a number to n significant digits. Generic formula. As in scientific notation: = ROUND. Excel Formula Training. Jump to Trend Line Equation and Coefficient of Determination - To show the trend line equation, select the. Or scientific notation), select the equation in the. If intercept is forced, coefficient of determination R2 is not calculated in the.
![Excel For Mac Trendline Formula Not In Scientific Notation Excel For Mac Trendline Formula Not In Scientific Notation](/uploads/1/2/5/6/125627236/337631068.webp)
The E in 4E+104 is part of scientific notation, meaning 4.10^104, and the e is the base of Napierian logarithms. Rather than use the values shown with limited precision in the trendline formula, you can get the coefficients on the worksheet using LINEST or LOGEST.
To use LINEST, select two cells (e.g., A1:B1) and array-enter this formula =LINEST(LN(y), x). Replacing y and x with appropriate cell references. Then A1 will contain m and B1 will contain b, and the reconstruction formula is =EXP(m.x+b).