Sep 22 2021 04:42 AM
I teach students using basic Excel. For the LINEST() function, I have switched over to using the dynamic array style: enter in one cell, no CSE, let the results spill.
I have a student using the exact same version as myself (16.53 (21091200) on macOS), but when he enters LINEST in this fashion, he only gets a single number. No spilling happens. He is not using Cntrl-Shft-Enter (I watched). Why would this be happening?
Sep 22 2021 06:22 AM
Sep 22 2021 11:46 AM
Solution@mtarlerThanks much for your troubleshooting help. It turns out that Excel had automatically added a "@" to the beginning of the formula. I'm not 100% sure what caused that. But of course removing it returned the expected results.