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....
IFS() shall be available for Excel 2019. Perhaps #NAME? error due to some other reason, not since IFS() doesn't exist in your environment.
Please try to open attached file with very simple IFS() sample to check if it works or not on your machine.