Fonction Si.condition (IFS function)

%3CLINGO-SUB%20id%3D%22lingo-sub-2047731%22%20slang%3D%22fr-FR%22%3ESi.condition%20function%20(IFS%20function)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047731%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20to%20work%20with%20the%20Excel%202019%20and%20then%20I%20started%20a%20new%20job%20and%20i%20need%20to%20work%20with%20Excel%202016.%20In%20all%20of%20my%20old%20excel%20files%20I%20used%20the%20IFS%20function%20and%20i%20can't%20work%20with%20them%20now.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20if%20it%20exists%20an%20alternative%20function%20for%20the%202016%20version%20or%20if%20i%20need%20to%20install%20some%20plug-in%20or%20extension.%26nbsp%3B%3C%2FP%3E%3CP%3EThx%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrench%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20used%20to%20working%20with%20the%20function%20though%2C%20conditions%20in%20the%20Excel%202019%20version%2C%20I%20recently%20started%20a%20new%20job%20and%20now%20I%20have%20to%20work%20with%20the%202016%20version%20of%20Excel.%20In%20my%20old%20spreadsheets%20I%20used%20the%20function%20a%20lot%20if%2C%20conditions%20but%20this%20function%20does%20not%20exist%20in%20the%202016%20version.%20I%20don't%20know%20if%20there%20is%20an%20alternative%20to%20this%20feature%20or%20if%20I%20need%20to%20download%20an%20update%20or%20an%20extension%20of%20the%20program.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2047731%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2047906%22%20slang%3D%22en-US%22%3ERe%3A%20Fonction%20Si.condition%20(IFS%20function)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F924328%22%20target%3D%22_blank%22%3E%40Dberch-groupeE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20available%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fofficepowerups.com%2F2016%2F06%2F03%2Fifs-function-excel-2013-2010-2007%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EIFS%20Function%20in%20Excel%202016%2C%202013%2C%202010%2C%20and%202007%20--%20just%20like%20Excel%202019%20or%20Excel%20365%20(officepowerups.com)%3C%2FA%3E%26nbsp%3Bbut%20I%20never%20tested%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good morning, 

 

I used to work with the Excel 2019 and then i started a new job and i need to work with Excel 2016. In all of my old excel files i used the IFS function and i can't work with them now. 

I dont know if it exist an alternative function for the 2016 version or if i need to install some plug-in or extension. 

Thx 

 

French : 

 

J'étais habitué à travailler avec la fonction si.conditions dans la version Excel 2019, j'ai récemment commencé un nouveau travail et je dois désormais travailler avec la version 2016 d'Excel. Dans mes anciennes fiches de calculs j'utilisais beaucoup la fonction si.conditions mais cette fonction n'existe pas dans la version 2016. Je ne sais pas si il existe une alternative à cette fonction ou si je dois télécharger une mise à jour ou une extension du programme. 

Merci 

1 Reply