Forum Discussion
Solved
Formula REGR.LIN output problem
Hi everyone, I've a problem with the formula REGR.LIN . In cell H6 I have wrote the formula as you can see in the pic that take the input data from the table on the left. Running the formula I ...
Sorry, forgot to mention. First you need to select both cells, after that enter the formula in formula in formula bar, next Ctrl+Shift+Enter.
Alternatively enter the formula into one cell, enter, select this and next cell, Ctrl+Shift+Enter
I've got Office 2019, I've tried to do what you suggested. But in the end I've got the same problem even if in the "formula bar" the formula is now between { }.
Sorry, forgot to mention. First you need to select both cells, after that enter the formula in formula in formula bar, next Ctrl+Shift+Enter.
Alternatively enter the formula into one cell, enter, select this and next cell, Ctrl+Shift+Enter