Ctrl+shift+enter in excel is not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1623891%22%20slang%3D%22en-US%22%3ECtrl%2Bshift%2Benter%20in%20excel%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623891%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20formula%20is%20working%20just%20fine%20in%20the%20google%20sheets%20version%20of%20the%20file%20but%20as%20soon%20as%20I%20open%20it%20in%20Excel%202016%20it%20doesn't%20work%20and%20just%20keeps%20saying%20that%20%22you've%20entered%20too%20few%20arguments%20for%20this%20function%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1638462%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2Bshift%2Benter%20in%20excel%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638462%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F777371%22%20target%3D%22_blank%22%3E%40edwards1330%3C%2FA%3E%26nbsp%3B%20You%20have%20posted%20on%20the%20Microsoft%20Learn%20community%20which%20is%20all%20about%20exams%2C%20certification%20and%20training.%3C%2FP%3E%0A%3CP%3EYou%20might%20get%20a%20better%20response%20on%20the%20Excel%20community%20board%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1644220%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2Bshift%2Benter%20in%20excel%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1644220%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F777371%22%20target%3D%22_blank%22%3E%40edwards1330%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoogle%20Sheets%20and%20Microsoft%20Excel%20are%20two%20completely%20different%20products%20from%20two%20companies.%20They%20have%20not%20aligned%20their%20development%20regarding%20features%20and%20functionalities.%20So%20the%20function%20may%20have%20the%20same%20name%20but%20the%20implementation%20and%20how%20to%20use%20it%20is%20up%20to%20Google%20or%20Microsoft.%3C%2FP%3E%3CP%3EI%20would%20search%20for%20a%20way%20to%20only%20use%20functions%20that%20are%20implemented%20in%20a%20similar%20way.%3C%2FP%3E%3CP%3ECheers%3CBR%20%2F%3ERolf%3CBR%20%2F%3E%23MCT%20%23LearnWithRolf%20%23TheCloud42%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

The formula is working just fine in the google sheets version of the file but as soon as I open it in Excel 2016 it doesn't work and just keeps saying that "you've entered too few arguments for this function".

 

 

2 Replies

@edwards1330  You have posted on the Microsoft Learn community which is all about exams, certification and training.

You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral

Hello @edwards1330

 

Google Sheets and Microsoft Excel are two completely different products from two companies. They have not aligned their development regarding features and functionalities. So the function may have the same name but the implementation and how to use it is up to Google or Microsoft.

I would search for a way to only use functions that are implemented in a similar way.

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42