Forum Discussion
Excel 16.43 Mac IFS Statement
Hi, Is the option to write an IFS statement only available to 365 subscribers? I just purchased Microsoft Excel 2019 today (one-time purchase) and my IFS statement keeps returning a #NAME? error....
This is not a recommendation because my use of Excel very likely differs from yours. However, Excel has changed so fundamentally from September 2018 onward with dynamic arrays, and now LET or even LAMDA, that I would not consider it to be the same program (though 365 will run legacy Excel).
If your requirement is for stability and the ability to run existing legacy spreadsheets and you need development to maintain compatibility with older versions, 2019 will do the job. For me, it would be utterly unsuitable and I would seek to cancel the purchase as unfit for purpose. It strikes me that now is not the best time to buy a fixed license, especially so as DA missed the cut.