translateformula.com
All language pairs

Translate Excel formulas between Spanish and French syntax

Paste a formula and function names, argument separators, boolean values and error values switch to the right language as you type. Further down: every Excel function name with its category and Excel version. No sign-in, no analytics, no cookies — everything runs in your browser.

Formula translator

Formula
Separators in the result
Translated 

            

          


          


        

      

    


    


    

      
The formula, part by part

      

        When you translate a formula it's broken down here, one function at a time, with what each argument does.
      

      

    


    

      
Every Excel function name

      

        Every Excel function name from A to Z, with its category and the earliest Excel version it appears in. The list is static and readable even without JavaScript.
      

      

        
        
      

      

      

        

          Excel functions: name, category and earliest Excel version.
          
            

              Spanish
              French
              Category
              Version
              Learn more
            

          
          



ABSABSMath and trigonometryAll


ACOSACOSMath and trigonometryAll


ACOSHACOSHMath and trigonometryAll


ACOTACOTMath and trigonometryAll


ACOTHACOTHMath and trigonometryAll


AGREGARAGREGATMath and trigonometryAll


AGRUPARPORGROUPER.PARLookup and reference365


AHORAMAINTENANTDate and timeAll


AJUSTARCOLSORGANISERCOLSLookup and reference2024


AJUSTARFILASORGANISERLIGNESLookup and reference2024


ALEATORIOALEAMath and trigonometryAll


ALEATORIO.ENTREALEA.ENTRE.BORNESMath and trigonometryAll


AMORTIZ.LINAMORLINCFinancialAll


AMORTIZ.PROGREAMORDEGRCFinancialAll


AÑOANNEEDate and timeAll


APILARHASSEMB.HLookup and reference2024


APILARVASSEMB.VLookup and reference2024


AREASZONESLookup and referenceAll


ASCASCTextAll


ASENOASINMath and trigonometryAll


ASENOHASINHMath and trigonometryAll


ATANATANMath and trigonometryAll


ATAN2ATAN2Math and trigonometryAll


ATANHATANHMath and trigonometryAll


BASEBASEMath and trigonometryAll


BDCONTARBDNBDatabaseAll


BDCONTARABDNBVALDatabaseAll


BDDESVESTBDECARTYPEDatabaseAll


BDDESVESTPBDECARTYPEPDatabaseAll


BDEXTRAERBDLIREDatabaseAll


BDMAXBDMAXDatabaseAll


BDMINBDMINDatabaseAll


BDPRODUCTOBDPRODUITDatabaseAll


BDPROMEDIOBDMOYENNEDatabaseAll


BDSUMABDSOMMEDatabaseAll


BDVARBDVARDatabaseAll


BDVARPBDVARPDatabaseAll


BESSELIBESSELIEngineeringAll


BESSELJBESSELJEngineeringAll


BESSELKBESSELKEngineeringAll


BESSELYBESSELYEngineeringAll


BIN.A.DECBINDECEngineeringAll


BIN.A.HEXBINHEXEngineeringAll


BIN.A.OCTBINOCTEngineeringAll


BINOM.CRITCRITERE.LOI.BINOMIALECompatibilityAll


BIT.DESPLDCHABITDECALDEngineeringAll


BIT.DESPLIZQDABITDECALGEngineeringAll


BIT.OBITOUEngineeringAll


BIT.XOBITOUEXCLUSIFEngineeringAll


BIT.YBITETEngineeringAll


BUSCARRECHERCHELookup and referenceAll


BUSCARHRECHERCHEHLookup and referenceAll


BUSCARVRECHERCHEVLookup and referenceAll


BUSCARXRECHERCHEXLookup and reference2021


BYCOLBYCOLLogical2024


BYROWBYROWLogical2024


CAMBIARSI.MULTIPLELogical2019


CANTIDAD.RECIBIDAVALEUR.NOMINALEFinancialAll


CARACTERCARTextAll


CELDACELLULEInformationAll


COCIENTEQUOTIENTMath and trigonometryAll


CODIGOCODETextAll


COEF.DE.CORRELCOEFFICIENT.CORRELATIONStatisticalAll


COEFICIENTE.ASIMETRIACOEFFICIENT.ASYMETRIEStatisticalAll


COEFICIENTE.ASIMETRIA.PCOEFFICIENT.ASYMETRIE.PStatisticalAll


COEFICIENTE.R2COEFFICIENT.DETERMINATIONStatisticalAll


COINCIDIREQUIVLookup and referenceAll


COINCIDIRXEQUIVXLookup and reference2021


COLUMNACOLONNELookup and referenceAll


COLUMNASCOLONNESLookup and referenceAll


COMBINACOMBINAMath and trigonometryAll


COMBINATCOMBINMath and trigonometryAll


COMPLEJOCOMPLEXEEngineeringAll


CONCATCONCATText2019


CONCATENARCONCATENERTextAll


CONJUNTOCUBOJEUCUBECubeAll


CONTARNBStatisticalAll


CONTAR.BLANCONB.VIDEStatisticalAll


CONTAR.SINB.SIStatisticalAll


CONTAR.SI.CONJUNTONB.SI.ENSStatisticalAll


CONTARANBVALStatisticalAll


CONV.DECIMALDECIMALMath and trigonometryAll


CONVERTIRCONVERTEngineeringAll


COSCOSMath and trigonometryAll


COSHCOSHMath and trigonometryAll


COTCOTMath and trigonometryAll


COTHCOTHMath and trigonometryAll


COVARCOVARIANCECompatibilityAll


COVARIANCE.PCOVARIANCE.PEARSONStatisticalAll


COVARIANZA.MCOVARIANCE.STANDARDStatisticalAll


CRECIMIENTOCROISSANCEStatisticalAll


CSCCSCMath and trigonometryAll


CSCHCSCHMath and trigonometryAll


CUARTILQUARTILECompatibilityAll


CUARTIL.EXCQUARTILE.EXCLUREStatisticalAll


CUARTIL.INCQUARTILE.INCLUREStatisticalAll


CUPON.DIASNB.JOURS.COUPONSFinancialAll


CUPON.DIAS.L1NB.JOURS.COUPON.PRECFinancialAll


CUPON.DIAS.L2NB.JOURS.COUPON.SUIVFinancialAll


CUPON.FECHA.L1DATE.COUPON.PRECFinancialAll


CUPON.FECHA.L2DATE.COUPON.SUIVFinancialAll


CUPON.NUMNB.COUPONSFinancialAll


CURTOSISKURTOSISStatisticalAll


DBDBFinancialAll


DBCSDBCSTextAll


DBCSDBCSTextAll


DDBDDBFinancialAll


DEC.A.BINDECBINEngineeringAll


DEC.A.HEXDECHEXEngineeringAll


DEC.A.OCTDECOCTEngineeringAll


DECIMALCTXTTextAll


DELTADELTAEngineeringAll


DERECHADROITETextAll


DERECHABDROITEBTextAll


DESREFDECALERLookup and referenceAll


DESVESTECARTYPECompatibilityAll


DESVEST.MECARTYPE.STANDARDStatisticalAll


DESVEST.PECARTYPE.PEARSONStatisticalAll


DESVESTASTDEVAStatisticalAll


DESVESTPECARTYPEPCompatibilityAll


DESVESTPASTDEVPAStatisticalAll


DESVIA2SOMME.CARRES.ECARTSStatisticalAll


DESVPROMECART.MOYENStatisticalAll


DETECTARIDIOMADETECTLANGUAGEText365


DIAJOURDate and timeAll


DIA.LABSERIE.JOUR.OUVREDate and timeAll


DIA.LAB.INTLSERIE.JOUR.OUVRE.INTLDate and timeAll


DIASJOURSDate and timeAll


DIAS.LABNB.JOURS.OUVRESDate and timeAll


DIAS.LAB.INTLNB.JOURS.OUVRES.INTLDate and timeAll


DIAS360JOURS360Date and timeAll


DIASEMJOURSEMDate and timeAll


DIRECCIONADRESSELookup and referenceAll


DIST.WEIBULLLOI.WEIBULLCompatibilityAll


DISTR.BETALOI.BETACompatibilityAll


DISTR.BETA.INVBETA.INVERSECompatibilityAll


DISTR.BETA.INVBETA.INVERSE.NStatisticalAll


DISTR.BETA.NLOI.BETA.NCompatibilityAll


DISTR.BINOMLOI.BINOMIALECompatibilityAll


DISTR.BINOM.NLOI.BINOMIALE.NStatisticalAll


DISTR.BINOM.SERIELOI.BINOMIALE.SERIEStatisticalAll


DISTR.CHILOI.KHIDEUXCompatibilityAll


DISTR.CHICUADLOI.KHIDEUX.NStatisticalAll


DISTR.CHICUAD.CDLOI.KHIDEUX.DROITEStatisticalAll


DISTR.EXPLOI.EXPONENTIELLECompatibilityAll


DISTR.EXP.NLOI.EXPONENTIELLE.NStatisticalAll


DISTR.FLOI.FCompatibilityAll


DISTR.F.CDLOI.F.DROITEStatisticalAll


DISTR.F.INVINVERSE.LOI.FCompatibilityAll


DISTR.F.NLOI.F.NStatisticalAll


DISTR.GAMMALOI.GAMMACompatibilityAll


DISTR.GAMMA.INVLOI.GAMMA.INVERSECompatibilityAll


DISTR.GAMMA.NLOI.GAMMA.NStatisticalAll


DISTR.HIPERGEOMLOI.HYPERGEOMETRIQUECompatibilityAll


DISTR.HIPERGEOM.NLOI.HYPERGEOMETRIQUE.NStatisticalAll


DISTR.LOG.INVLOI.LOGNORMALE.INVERSECompatibilityAll


DISTR.LOG.NORMLOI.LOGNORMALECompatibilityAll


DISTR.LOGNORMLOI.LOGNORMALE.NStatisticalAll


DISTR.NORMLOI.NORMALECompatibilityAll


DISTR.NORM.ESTANDLOI.NORMALE.STANDARDCompatibilityAll


DISTR.NORM.ESTAND.INVLOI.NORMALE.STANDARD.INVERSECompatibilityAll


DISTR.NORM.ESTAND.NLOI.NORMALE.STANDARD.NStatisticalAll


DISTR.NORM.INVLOI.NORMALE.INVERSEStatisticalAll


DISTR.NORM.NLOI.NORMALE.NStatisticalAll


DISTR.TLOI.STUDENTCompatibilityAll


DISTR.T.2CLOI.STUDENT.BILATERALEStatisticalAll


DISTR.T.CDLOI.STUDENT.DROITEStatisticalAll


DISTR.T.INVLOI.STUDENT.INVERSECompatibilityAll


DISTR.T.NLOI.STUDENT.NStatisticalAll


DISTR.WEIBULLLOI.WEIBULL.NStatisticalAll


DIVIDIRTEXTOFRACTIONNER.TEXTEText2024


DROPDROPLookup and reference2024


DURACIONDUREEFinancialAll


DURACION.MODIFDUREE.MODIFIEEFinancialAll


DVSVDBFinancialAll


ELEGIRCHOISIRLookup and referenceAll


ELEGIRCOLSCHOISIRCOLSLookup and reference2024


ELEGIRFILASCHOISIRLIGNESLookup and reference2024


ENCOLDANSCOLLookup and reference2024


ENCONTRARTROUVETextAll


ENCONTRARBTROUVERBTextAll


ENFILADANSLIGNELookup and reference2024


ENTEROENTMath and trigonometryAll


ERROR.TIPICO.XYERREUR.TYPE.XYStatisticalAll


ES.IMPAREST.IMPAIRInformationAll


ES.PAREST.PAIRInformationAll


ESBLANCOESTVIDEInformationAll


ESERRESTERRInformationAll


ESERRORESTERREURInformationAll


ESFORMULAESTFORMULEInformationAll


ESLOGICOESTLOGIQUEInformationAll


ESNODESTNAInformationAll


ESNOTEXTOESTNONTEXTEInformationAll


ESNUMEROESTNUMInformationAll


ESPACIOSSUPPRESPACETextAll


ESREFESTREFInformationAll


ESTEXTOESTTEXTEInformationAll


ESTIMACION.LINEALDROITEREGStatisticalAll


ESTIMACION.LOGARITMICALOGREGStatisticalAll


EUROCONVERTEUROCONVERTAdd-in and AutomationAll


EXPEXPMath and trigonometryAll


EXPANDIREXPANDLookup and reference2024


EXTRAESTXTTextAll


EXTRAEBMIDBTextAll


FACTFACTMath and trigonometryAll


FACT.DOBLEFACTDOUBLEMath and trigonometryAll


FALSOFAUXLogicalAll


FECHADATEDate and timeAll


FECHA.MESMOIS.DECALERDate and timeAll


FECHANUMERODATEVALDate and timeAll


FIPHIStatisticalAll


FILALIGNELookup and referenceAll


FILASLIGNESLookup and referenceAll


FILTRARFILTRELookup and reference2021


FIN.MESFIN.MOISDate and timeAll


FISHERFISHERStatisticalAll


FONETICOPHONETIQUETextAll


FORMULATEXTOFORMULETEXTELookup and referenceAll


FRAC.AÑOFRACTION.ANNEEDate and timeAll


FRECUENCIAFREQUENCEStatisticalAll


FUN.ERRORERFEngineeringAll


FUN.ERROR.COMPLERFCEngineeringAll


FUN.ERROR.COMPL.EXACTOERFC.PRECISEngineeringAll


FUN.ERROR.EXACTOERF.PRECISEngineeringAll


GAMMAGAMMAStatisticalAll


GAMMA.LNLNGAMMAStatisticalAll


GAMMA.LN.EXACTOLNGAMMA.PRECISStatisticalAll


GAUSSGAUSSStatisticalAll


GRADOSDEGRESMath and trigonometryAll


HALLARCHERCHETextAll


HALLARBCHERCHERBTextAll


HEX.A.BINHEXBINEngineeringAll


HEX.A.DECHEXDECEngineeringAll


HEX.A.OCTHEXOCTEngineeringAll


HIPERVINCULOLIEN_HYPERTEXTELookup and referenceAll


HISTORIALCOTIZACIONESHISTORIQUE.ACTIONSInformationAll


HOJAFEUILLEInformationAll


HOJASFEUILLESInformationAll


HORAHEUREDate and timeAll


HORANUMEROTEMPSVALDate and timeAll


HOYAUJOURDHUIDate and timeAll


ID.REGISTROREGISTRE.NUMEROAdd-in and AutomationAll


IGUALEXACTTextAll


IM.ABSCOMPLEXE.MODULEEngineeringAll


IM.ANGULOCOMPLEXE.ARGUMENTEngineeringAll


IM.CONJUGADACOMPLEXE.CONJUGUEEngineeringAll


IM.COSCOMPLEXE.COSEngineeringAll


IM.COSHCOMPLEXE.COSHEngineeringAll


IM.COTCOMPLEXE.COTEngineeringAll


IM.CSCCOMPLEXE.CSCEngineeringAll


IM.CSCHCOMPLEXE.CSCHEngineeringAll


IM.DIVCOMPLEXE.DIVEngineeringAll


IM.EXPCOMPLEXE.EXPEngineeringAll


IM.LNCOMPLEXE.LNEngineeringAll


IM.LOG10COMPLEXE.LOG10EngineeringAll


IM.LOG2COMPLEXE.LOG2EngineeringAll


IM.POTCOMPLEXE.PUISSANCEEngineeringAll


IM.PRODUCTCOMPLEXE.PRODUITEngineeringAll


IM.RAIZ2COMPLEXE.RACINEEngineeringAll


IM.REALCOMPLEXE.REELEngineeringAll


IM.SECCOMPLEXE.SECEngineeringAll


IM.SECHCOMPLEXE.SECHEngineeringAll


IM.SENOCOMPLEXE.SINEngineeringAll


IM.SENOHCOMPLEXE.SINHEngineeringAll


IM.SUMCOMPLEXE.SOMMEEngineeringAll


IM.SUSTRCOMPLEXE.DIFFERENCEEngineeringAll


IM.TANCOMPLEXE.TANEngineeringAll


IMAGENIMAGELookup and reference2024


IMAGINARIOCOMPLEXE.IMAGINAIREEngineeringAll


IMPORTARDATOSDINAMICOSLIREDONNEESTABCROISDYNAMIQUELookup and referenceAll


INDICEINDEXLookup and referenceAll


INDIRECTOINDIRECTLookup and referenceAll


INFOINFORMATIONSInformationAll


INT.ACUMINTERET.ACCFinancialAll


INT.ACUM.VINTERET.ACC.MATFinancialAll


INT.EFECTIVOTAUX.EFFECTIFFinancialAll


INT.PAGO.DIRISPMTFinancialAll


INTERSECCION.EJEORDONNEE.ORIGINEStatisticalAll


INTERVALO.CONFIANZAINTERVALLE.CONFIANCECompatibilityAll


INTERVALO.CONFIANZA.NORMINTERVALLE.CONFIANCE.NORMALStatisticalAll


INTERVALO.CONFIANZA.TINTERVALLE.CONFIANCE.STUDENTStatisticalAll


INV.BINOMLOI.BINOMIALE.INVERSEStatisticalAll


INV.CHICUADLOI.KHIDEUX.INVERSEStatisticalAll


INV.CHICUAD.CDLOI.KHIDEUX.INVERSE.DROITEStatisticalAll


INV.FINVERSE.LOI.F.NStatisticalAll


INV.F.CDINVERSE.LOI.F.DROITEStatisticalAll


INV.GAMMALOI.GAMMA.INVERSE.NStatisticalAll


INV.LOGNORMLOI.LOGNORMALE.INVERSE.NStatisticalAll


INV.NORMLOI.NORMALE.INVERSE.NCompatibilityAll


INV.NORM.ESTANDLOI.NORMALE.STANDARD.INVERSE.NStatisticalAll


INV.TLOI.STUDENT.INVERSE.NStatisticalAll


INV.T.2CLOI.STUDENT.INVERSE.BILATERALEStatisticalAll


ISO.NUM.DE.SEMANANO.SEMAINE.ISODate and timeAll


ISOMITTEDISOMITTEDInformation2024


IZQUIERDAGAUCHETextAll


IZQUIERDABGAUCHEBTextAll


JERARQUIARANGCompatibilityAll


JERARQUIA.EQVEQUATION.RANGStatisticalAll


JERARQUIA.MEDIAMOYENNE.RANGStatisticalAll


K.ESIMO.MAYORGRANDE.VALEURStatisticalAll


K.ESIMO.MENORPETITE.VALEURStatisticalAll


LAMBDALAMBDALogical2024


LARGONBCARTextAll


LARGOBLENBTextAll


LETLETLogical2021


LETRA.DE.TES.PRECIOPRIX.BON.TRESORFinancialAll


LETRA.DE.TES.RENDTORENDEMENT.BON.TRESORFinancialAll


LETRA.DE.TEST.EQV.A.BONOTAUX.ESCOMPTE.RFinancialAll


LIMPIAREPURAGETextAll


LLAMARFONCTION.APPELANTEAdd-in and AutomationAll


LNLNMath and trigonometryAll


LOGLOGMath and trigonometryAll


LOG10LOG10Math and trigonometryAll


M.C.DPGCDMath and trigonometryAll


M.C.MPPCMMath and trigonometryAll


M.UNIDADMATRICE.UNITAIREMath and trigonometryAll


MAKEARRAYMAKEARRAYLogical2024


MAPCARTELogical2024


MATRIZALEATTABLEAU.ALEATMath and trigonometry2021


MATRIZATEXTOTABLEAU.EN.TEXTEText2021


MAXMAXStatisticalAll


MAX.SI.CONJUNTOMAX.SIStatistical2019


MAXAMAXAStatisticalAll


MAYOR.O.IGUALSUP.SEUILEngineeringAll


MAYUSCMAJUSCULETextAll


MDETERMDETERMATMath and trigonometryAll


MEDIA.ACOTADAMOYENNE.REDUITEStatisticalAll


MEDIA.ARMOMOYENNE.HARMONIQUEStatisticalAll


MEDIA.GEOMMOYENNE.GEOMETRIQUEStatisticalAll


MEDIANAMEDIANEStatisticalAll


MESMOISDate and timeAll


MIEMBROCUBOMEMBRECUBECubeAll


MIEMBROKPICUBOMEMBREKPICUBECubeAll


MIEMBRORANGOCUBORANGMEMBRECUBECubeAll


MINMINStatisticalAll


MIN.SI.CONJUNTOMIN.SIStatistical2019


MINAMINAStatisticalAll


MINUSCMINUSCULETextAll


MINUTOMINUTEDate and timeAll


MINVERSAINVERSEMATMath and trigonometryAll


MMULTPRODUITMATMath and trigonometryAll


MODAMODECompatibilityAll


MODA.UNOMODE.SIMPLEStatisticalAll


MODA.VARIOSMODE.MULTIPLEStatisticalAll


MONEDADEVISETextAll


MONEDA.DECPRIX.DECFinancialAll


MONEDA.FRACPRIX.FRACFinancialAll


MULTINOMIALMULTINOMIALEMath and trigonometryAll


MULTIPLO.INFERIORPLANCHERCompatibilityAll


MULTIPLO.INFERIOR.EXACTOPLANCHER.PRECISMath and trigonometryAll


MULTIPLO.INFERIOR.MATPLANCHER.MATHMath and trigonometryAll


MULTIPLO.SUPERIORPLAFONDCompatibilityAll


MULTIPLO.SUPERIOR.EXACTOPLAFOND.PRECISMath and trigonometryAll


MULTIPLO.SUPERIOR.ISOISO.PLAFONDMath and trigonometryAll


MULTIPLO.SUPERIOR.MATPLAFOND.MATHMath and trigonometryAll


NNInformationAll


NEGBINOM.DISTLOI.BINOMIALE.NEG.NStatisticalAll


NEGBINOMDISTLOI.BINOMIALE.NEGCompatibilityAll


NONONLogicalAll


NODNAInformationAll


NOMPROPIONOMPROPRETextAll


NORMALIZACIONCENTREE.REDUITEStatisticalAll


NPERNPMFinancialAll


NSHORATEMPSDate and timeAll


NUM.DE.SEMANANO.SEMAINEDate and timeAll


NUMERO.ARABECHIFFRE.ARABEMath and trigonometryAll


NUMERO.ROMANOROMAINMath and trigonometryAll


OOULogicalAll


OCT.A.BINOCTBINEngineeringAll


OCT.A.DECOCTDECEngineeringAll


OCT.A.HEXOCTHEXEngineeringAll


ORDENARTRIERLookup and reference2021


ORDENARPORTRIERPARLookup and reference2021


P.DURACIONPDUREEFinancialAll


PAGOVPMFinancialAll


PAGO.INT.ENTRECUMUL.INTERFinancialAll


PAGO.PRINC.ENTRECUMUL.PRINCPERFinancialAll


PAGOINTINTPERFinancialAll


PAGOPRINPRINCPERFinancialAll


PEARSONPEARSONStatisticalAll


PENDIENTEPENTEStatisticalAll


PERCENTILCENTILECompatibilityAll


PERCENTIL.EXCCENTILE.EXCLUREStatisticalAll


PERCENTIL.INCCENTILE.INCLUREStatisticalAll


PERCENTOFPOURCENTAGE.DEMath and trigonometry365


PERMUTACIONESPERMUTATIONStatisticalAll


PERMUTACIONES.APERMUTATIONAStatisticalAll


PIPIMath and trigonometryAll


PIVOTARPORPIVOTER.PARLookup and reference365


POISSONLOI.POISSONCompatibilityAll


POISSON.DISTLOI.POISSON.NStatisticalAll


POTENCIAPUISSANCEMath and trigonometryAll


PRECIOPRIX.TITREFinancialAll


PRECIO.DESCUENTOVALEUR.ENCAISSEMENTFinancialAll


PRECIO.PER.IRREGULAR.1PRIX.PCOUPON.IRREGFinancialAll


PRECIO.PER.IRREGULAR.2PRIX.DCOUPON.IRREGFinancialAll


PRECIO.VENCIMIENTOPRIX.TITRE.ECHEANCEFinancialAll


PROBABILIDADPROBABILITEStatisticalAll


PRODUCTOPRODUITMath and trigonometryAll


PROMEDIOMOYENNEStatisticalAll


PROMEDIO.SIMOYENNE.SIStatisticalAll


PROMEDIO.SI.CONJUNTOMOYENNE.SI.ENSStatisticalAll


PROMEDIOAAVERAGEAStatisticalAll


PRONOSTICOPREVISIONStatisticalAll


PRONOSTICO.ETSPREVISION.ETSStatisticalAll


PRONOSTICO.ETS.CONFINTPREVISION.ETS.CONFINTStatisticalAll


PRONOSTICO.ETS.ESTACIONALIDADPREVISION.ETS.CARACTERESAISONNIERStatisticalAll


PRONOSTICO.ETS.STATPREVISION.ETS.STATStatisticalAll


PRONOSTICO.LINEALPREVISION.LINEAIREStatisticalAll


PROPIEDADMIEMBROCUBOPROPRIETEMEMBRECUBECubeAll


PRUEBA.CHITEST.KHIDEUXCompatibilityAll


PRUEBA.CHI.INVKHIDEUX.INVERSECompatibilityAll


PRUEBA.CHICUADCHISQ.TESTStatisticalAll


PRUEBA.FTEST.FCompatibilityAll


PRUEBA.F.NF.TESTStatisticalAll


PRUEBA.FISHER.INVFISHER.INVERSEStatisticalAll


PRUEBA.TTEST.STUDENTCompatibilityAll


PRUEBA.T.NT.TESTStatisticalAll


PRUEBA.ZTEST.ZCompatibilityAll


PRUEBA.Z.NZ.TESTStatisticalAll


RADIANESRADIANSMath and trigonometryAll


RAIZRACINEMath and trigonometryAll


RAIZ2PIRACINE.PIMath and trigonometryAll


RANGO.PERCENTILRANG.POURCENTAGECompatibilityAll


RANGO.PERCENTIL.EXCRANG.POURCENTAGE.EXCLUREStatisticalAll


RANGO.PERCENTIL.INCRANG.POURCENTAGE.INCLUREStatisticalAll


RDTRRTDLookup and referenceAll


RECORTAR.RANGOTRIMRANGELookup and reference365


RECUENTOCONJUNTOCUBONBJEUCUBECubeAll


REDOND.MULTARRONDI.AU.MULTIPLEMath and trigonometryAll


REDONDEA.IMPARIMPAIRMath and trigonometryAll


REDONDEA.PARPAIRMath and trigonometryAll


REDONDEARARRONDIMath and trigonometryAll


REDONDEAR.MASARRONDI.SUPMath and trigonometryAll


REDONDEAR.MENOSARRONDI.INFMath and trigonometryAll


REDUCEREDUIRELogical2024


REEMPLAZARREMPLACERTextAll


REEMPLAZARBREMPLACERBTextAll


REGEXEXTRACTREGEXEXTRACTText365


REGEXREPLACEREGEXREPLACEText365


REGEXTESTREGEXTESTText365


RENDTORENDEMENT.TITREFinancialAll


RENDTO.DESCRENDEMENT.SIMPLEFinancialAll


RENDTO.PER.IRREGULAR.1REND.PCOUPON.IRREGFinancialAll


RENDTO.PER.IRREGULAR.2REND.DCOUPON.IRREGFinancialAll


RENDTO.VENCTORENDEMENT.TITRE.ECHEANCEFinancialAll


REPETIRREPTTextAll


RESIDUOMODMath and trigonometryAll


RRITAUX.INT.EQUIVFinancialAll


SCANSCANLogical2024


SECSECMath and trigonometryAll


SECHSECHMath and trigonometryAll


SECUENCIASEQUENCEMath and trigonometry2021


SEGUNDOSECONDEDate and timeAll


SENOSINMath and trigonometryAll


SENOHSINHMath and trigonometryAll


SERVICIOWEBSERVICEWEBWebAll


SISILogicalAll


SI.CONJUNTOSI.CONDITIONSLogical2019


SI.ERRORSIERREURLogicalAll


SI.NDSI.NON.DISPLogicalAll


SIFECHADATEDIFDate and timeAll


SIGNOSIGNEMath and trigonometryAll


SLNAMORLINFinancialAll


SUBTOTALESSOUS.TOTALMath and trigonometryAll


SUMASOMMEMath and trigonometryAll


SUMA.CUADRADOSSOMME.CARRESMath and trigonometryAll


SUMA.SERIESSOMME.SERIESMath and trigonometryAll


SUMAPRODUCTOSOMMEPRODMath and trigonometryAll


SUMAR.SISOMME.SIMath and trigonometryAll


SUMAR.SI.CONJUNTOSOMME.SI.ENSMath and trigonometryAll


SUMAX2MASY2SOMME.X2PY2Math and trigonometryAll


SUMAX2MENOSY2SOMME.X2MY2Math and trigonometryAll


SUMAXMENOSY2SOMME.XMY2Math and trigonometryAll


SUSTITUIRSUBSTITUETextAll


SYDSYDFinancialAll


TTTextAll


TANTANMath and trigonometryAll


TANHTANHMath and trigonometryAll


TASATAUXFinancialAll


TASA.DESCTAUX.ESCOMPTEFinancialAll


TASA.INTTAUX.INTERETFinancialAll


TASA.NOMINALTAUX.NOMINALFinancialAll


TENDENCIATENDANCEStatisticalAll


TEXTOTEXTETextAll


TEXTOANTESTEXTE.AVANTText2024


TEXTOBAHTBAHTTEXTTextAll


TEXTODESPUESTEXTE.APRESText2024


TIPOTYPEInformationAll


TIPO.DE.ERRORTYPE.ERREURInformationAll


TIRTRIFinancialAll


TIR.NO.PERTRI.PAIEMENTSFinancialAll


TIRMTRIMFinancialAll


TOMARPRENDRELookup and reference2024


TRADUCIRTRADUIREText365


TRANSPONERTRANSPOSELookup and referenceAll


TRUNCARTRONQUEMath and trigonometryAll


UNICARUNICARTextAll


UNICODEUNICODETextAll


UNICOSUNIQUELookup and reference2021


UNIRCADENASJOINDRE.TEXTEText2019


URLCODIFURLENCODAGEWebAll


VAVAFinancialAll


VALORCNUMTextAll


VALOR.NUMEROVALEURNOMBRETextAll


VALORATEXTOVALEUR.EN.TEXTEText2021


VALORCUBOVALEURCUBECubeAll


VARVARCompatibilityAll


VAR.PVAR.P.NStatisticalAll


VAR.SVAR.SStatisticalAll


VARAVARAStatisticalAll


VARPVAR.PCompatibilityAll


VARPAVARPAStatisticalAll


VERDADEROVRAILogicalAll


VFVCFinancialAll


VF.PLANVC.PAIEMENTSFinancialAll


VNAVANFinancialAll


VNA.NO.PERVAN.PAIEMENTSFinancialAll


XMLFILTROFILTRE.XMLWebAll


XOOUXLogicalAll


YETLogicalAll


          
        

      

    


    


    

      
Common error values in Excel

      

        Error values are named differently across Excel languages. The search box above finds them too – type #N/A.
      

      

        

          
            

              Spanish
              French
              What it means – and the most common cause
            

          
          
            
#N/D#N/AA value isn't available. Most common: VLOOKUP, MATCH or XLOOKUP can't find what you're looking for.

            
#¡VALOR!#VALEUR!Wrong type of value. Most common: text where the formula expects a number, or maths on a cell that contains text.

            
#¡REF!#REF!A reference points at a cell that no longer exists. Most common: rows or columns the formula used have been deleted.

            
#¡DIV/0!#DIV/0!Division by zero or by an empty cell.

            
#¿NOMBRE?#NOM?Excel doesn't recognise a name. Most common: a misspelled function name, text without quotes, or a named range that doesn't exist.

            
#¡NUM!#NOMBRE!A number is invalid or too large. Most common: the square root of a negative number, or a result too big for Excel.

            
#¡NULO!#NUL!Two ranges that should intersect don't. Most common: a space instead of a separator between two ranges.

            
#¡DESBORDAMIENTO!#PROPAGATION!A dynamic array can't fit. Most common: a cell in the spill range is already occupied.

          
        

      

    


    

      
Go deeper into Excel functions

      
Learnesy has detailed walkthroughs of every Excel function, plus free courses.