Forum Discussion
Formula REGR.LIN output problem
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
Depends on which version of Excel you are. If on 2021 or 365 it shall show both value. If another one, enter formula as array one, i.e. use Ctrl+Shift+Enter instead of 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