Excel 16.43 Mac IFS Statement

%3CLINGO-SUB%20id%3D%22lingo-sub-1983820%22%20slang%3D%22en-US%22%3EExcel%2016.43%20Mac%20IFS%20Statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1983820%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20the%20option%20to%20write%20an%20IFS%20statement%20only%20available%20to%20365%20subscribers%3F%20I%20just%20purchased%20Microsoft%20Excel%202019%20today%20(one-time%20purchase)%20and%20my%20IFS%20statement%20keeps%20returning%20a%20%23NAME%3F%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20syntax%20looks%20correct%2C%20I'm%20not%20sure%20what%20the%20problem%20is.%20Any%20thoughts%20are%20much%20appreciated%2C%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1983820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984300%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016.43%20Mac%20IFS%20Statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F900615%22%20target%3D%22_blank%22%3E%40nandoq711%3C%2FA%3E%26nbsp%3BThe%20Mac%20help%20screen%20says%20this%20about%20IFS%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-14%20at%2007.24.40.png%22%20style%3D%22width%3A%20494px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F240100i5FA548B884995395%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-14%20at%2007.24.40.png%22%20alt%3D%22Screenshot%202020-12-14%20at%2007.24.40.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984302%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016.43%20Mac%20IFS%20Statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F900615%22%20target%3D%22_blank%22%3E%40nandoq711%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20there%20is%20no%20way%20you%20can%20get%20subscription%20features%20to%20the%20standalone%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehowever%2C%20you%20can%20still%20us%20Excel%20for%20web%20which%20supports%20subscription%20Excel%20function%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23999999%22%3E%3CEM%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3BOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FEM%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984336%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016.43%20Mac%20IFS%20Statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F900615%22%20target%3D%22_blank%22%3E%40nandoq711%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20a%20recommendation%20because%20my%20use%20of%20Excel%20very%20likely%20differs%20from%20yours.%26nbsp%3B%20However%2C%20Excel%20has%20changed%20so%20fundamentally%20from%20September%202018%20onward%20with%20dynamic%20arrays%2C%20and%20now%20LET%20or%20even%20LAMDA%2C%20that%20I%20would%20not%20consider%20it%20to%20be%20the%20same%20program%20(though%20365%20will%20run%20legacy%20Excel).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20your%20requirement%20is%20for%20stability%20and%20the%20ability%20to%20run%20existing%20legacy%20spreadsheets%20and%20you%20need%20development%20to%20maintain%20compatibility%20with%20older%20versions%2C%202019%20will%20do%20the%20job.%26nbsp%3B%20For%20me%2C%20it%20would%20be%20utterly%20unsuitable%20and%20I%20would%20seek%20to%20cancel%20the%20purchase%20as%20unfit%20for%20purpose.%26nbsp%3B%20It%20strikes%20me%20that%20now%20is%20not%20the%20best%20time%20to%20buy%20a%20fixed%20license%2C%20especially%20so%20as%20DA%20missed%20the%20cut.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

 

The syntax looks correct, I'm not sure what the problem is. Any thoughts are much appreciated, thank you.

4 Replies

@nandoq711 The Mac help screen says this about IFS

Screenshot 2020-12-14 at 07.24.40.png

Hi @nandoq711 

 

Unfortunately, there is no way you can get subscription features to the standalone version.

 

however, you can still us Excel for web which supports subscription Excel function

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

@nandoq711 

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.

@nandoq711 

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.