translateformula.com
All language pairs

Translate Excel formulas between Spanish and Norwegian 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
              Norwegian
              Category
              Version
              Learn more
            

          
          



ABSABSMath and trigonometryAll


ACOSARCCOSMath and trigonometryAll


ACOSHARCCOSHMath and trigonometryAll


ACOTACOTMath and trigonometryAll


ACOTHACOTHMath and trigonometryAll


AGREGARMENGDEMath and trigonometryAll


AGRUPARPORGROUPBYLookup and reference365


AHORANÅDate and timeAll


AJUSTARCOLSBRYTKOLLookup and reference2024


AJUSTARFILASBRYTRADERLookup and reference2024


ALEATORIOTILFELDIGMath and trigonometryAllLearnesy →


ALEATORIO.ENTRETILFELDIGMELLOMMath and trigonometryAllLearnesy →


AMORTIZ.LINAMORLINCFinancialAll


AMORTIZ.PROGREAMORDEGRCFinancialAll


AÑOÅRDate and timeAll


APILARHHSTAKKLookup and reference2024


APILARVVSTAKKLookup and reference2024


AREASOMRÅDERLookup and referenceAll


ASCSTIGENDETextAll


ASENOARCSINMath and trigonometryAll


ASENOHARCSINHMath and trigonometryAll


ATANARCTANMath and trigonometryAll


ATAN2ARCTAN2Math and trigonometryAll


ATANHARCTANHMath and trigonometryAll


BASEGRUNNTALLMath and trigonometryAll


BDCONTARDANTALLDatabaseAll


BDCONTARADANTALLADatabaseAll


BDDESVESTDSTDAVDatabaseAll


BDDESVESTPDSTAVPDatabaseAll


BDEXTRAERDHENTDatabaseAll


BDMAXDSTØRSTDatabaseAll


BDMINDMINDatabaseAll


BDPRODUCTODPRODUKTDatabaseAll


BDPROMEDIODGJENNOMSNITTDatabaseAll


BDSUMADSUMMERDatabaseAll


BDVARDVARIANSDatabaseAll


BDVARPDVARIANSPDatabaseAll


BESSELIBESSELIEngineeringAll


BESSELJBESSELJEngineeringAll


BESSELKBESSELKEngineeringAll


BESSELYBESSELYEngineeringAll


BIN.A.DECBINTILDESEngineeringAll


BIN.A.HEXBINTILHEKSEngineeringAll


BIN.A.OCTBINTILOKTEngineeringAll


BINOM.CRITGRENSE.BINOMCompatibilityAll


BIT.DESPLDCHABITHFORSKYVEngineeringAll


BIT.DESPLIZQDABITVFORSKYVEngineeringAll


BIT.OBITELLEREngineeringAll


BIT.XOBITEKSKLUSIVELLEREngineeringAll


BIT.YBITOGEngineeringAll


BUSCARSLÅ.OPPLookup and referenceAll


BUSCARHFINN.KOLONNELookup and referenceAllLearnesy →


BUSCARVFINN.RADLookup and referenceAllLearnesy →


BUSCARXXOPPSLAGLookup and reference2021Learnesy →


BYCOLETTERKOLLogical2024


BYROWETTERRADLogical2024


CAMBIARBRYTERLogical2019


CANTIDAD.RECIBIDAMOTTATT.AVKASTFinancialAll


CARACTERTEGNKODETextAll


CELDACELLEInformationAll


COCIENTEKVOTIENTMath and trigonometryAll


CODIGOKODETextAll


COEF.DE.CORRELKORRELASJONStatisticalAll


COEFICIENTE.ASIMETRIASKJEVFORDELINGStatisticalAll


COEFICIENTE.ASIMETRIA.PSKJEVFORDELING.PStatisticalAll


COEFICIENTE.R2RKVADRATStatisticalAll


COINCIDIRSAMMENLIGNELookup and referenceAllLearnesy →


COINCIDIRXXSAMSVARLookup and reference2021


COLUMNAKOLONNELookup and referenceAll


COLUMNASKOLONNERLookup and referenceAll


COMBINAKOMBINASJONAMath and trigonometryAll


COMBINATKOMBINASJONMath and trigonometryAll


COMPLEJOKOMPLEKSEngineeringAll


CONCATKJED.SAMMENText2019


CONCATENARKJEDE.SAMMENTextAll


CONJUNTOCUBOKUBESETTCubeAll


CONTARANTALLStatisticalAllLearnesy →


CONTAR.BLANCOTELLBLANKEStatisticalAllLearnesy →


CONTAR.SIANTALL.HVISStatisticalAllLearnesy →


CONTAR.SI.CONJUNTOANTALL.HVIS.SETTStatisticalAllLearnesy →


CONTARAANTALLAStatisticalAllLearnesy →


CONV.DECIMALDESIMALMath and trigonometryAll


CONVERTIRKONVERTEREngineeringAll


COSCOSMath and trigonometryAll


COSHCOSHMath and trigonometryAll


COTCOTMath and trigonometryAll


COTHCOTHMath and trigonometryAll


COVARKOVARIANSCompatibilityAll


COVARIANCE.PKOVARIANS.PStatisticalAll


COVARIANZA.MKOVARIANS.SStatisticalAll


CRECIMIENTOVEKSTStatisticalAll


CSCCSCMath and trigonometryAll


CSCHCSCHMath and trigonometryAll


CUARTILKVARTILCompatibilityAllLearnesy →


CUARTIL.EXCKVARTIL.EKSStatisticalAll


CUARTIL.INCKVARTIL.INKStatisticalAll


CUPON.DIASOBLIG.DAGERFinancialAll


CUPON.DIAS.L1OBLIG.DAGER.FFFinancialAll


CUPON.DIAS.L2OBLIG.DAGER.NFFinancialAll


CUPON.FECHA.L1OBLIG.DAG.FORRIGEFinancialAll


CUPON.FECHA.L2OBLIG.DAGER.EFFinancialAll


CUPON.NUMOBLIG.ANTALLFinancialAll


CURTOSISKURTStatisticalAll


DBDAVSKRFinancialAllLearnesy →


DBCSDBCSTextAll


DBCSJISTextAll


DDBDEGRAVSFinancialAllLearnesy →


DEC.A.BINDESTILBINEngineeringAll


DEC.A.HEXDESTILHEKSEngineeringAll


DEC.A.OCTDESTILOKTEngineeringAll


DECIMALFASTSATTTextAll


DELTADELTAEngineeringAll


DERECHAHØYRETextAllLearnesy →


DERECHABHØYREBTextAll


DESREFFORSKYVNINGLookup and referenceAllLearnesy →


DESVESTSTDAVCompatibilityAllLearnesy →


DESVEST.MSTDAV.SStatisticalAll


DESVEST.PSTDAV.PStatisticalAll


DESVESTASTDAVVIKAStatisticalAll


DESVESTPSTDAVPCompatibilityAll


DESVESTPASTDAVVIKPAStatisticalAll


DESVIA2AVVIK.KVADRERTStatisticalAll


DESVPROMGJENNOMSNITTSAVVIKStatisticalAll


DETECTARIDIOMADETECTLANGUAGEText365


DIADAGDate and timeAll


DIA.LABARBEIDSDAGDate and timeAllLearnesy →


DIA.LAB.INTLARBEIDSDAG.INTLDate and timeAll


DIASDAGERDate and timeAll


DIAS.LABNETT.ARBEIDSDAGERDate and timeAllLearnesy →


DIAS.LAB.INTLNETT.ARBEIDSDAGER.INTLDate and timeAll


DIAS360DAGER360Date and timeAll


DIASEMUKEDAGDate and timeAllLearnesy →


DIRECCIONADRESSELookup and referenceAll


DIST.WEIBULLWEIBULL.FORDELINGCompatibilityAll


DISTR.BETABETA.FORDELINGCompatibilityAll


DISTR.BETA.INVINVERS.BETA.FORDELINGCompatibilityAll


DISTR.BETA.INVBETA.INVStatisticalAll


DISTR.BETA.NBETA.FORDELINGCompatibilityAll


DISTR.BINOMBINOM.FORDELINGCompatibilityAll


DISTR.BINOM.NBINOM.FORDELINGStatisticalAll


DISTR.BINOM.SERIEBINOM.FORDELING.OMRÅDEStatisticalAll


DISTR.CHIKJI.FORDELINGCompatibilityAll


DISTR.CHICUADKJIKVADRAT.FORDELINGStatisticalAll


DISTR.CHICUAD.CDKJIKVADRAT.FORDELING.HStatisticalAll


DISTR.EXPEKSP.FORDELINGCompatibilityAll


DISTR.EXP.NEKSP.FORDELINGStatisticalAll


DISTR.FFFORDELINGCompatibilityAll


DISTR.F.CDF.FORDELING.HStatisticalAll


DISTR.F.INVFFORDELING.INVERSCompatibilityAll


DISTR.F.NF.FORDELINGStatisticalAll


DISTR.GAMMAGAMMAFORDELINGCompatibilityAll


DISTR.GAMMA.INVGAMMAINVCompatibilityAll


DISTR.GAMMA.NGAMMA.FORDELINGStatisticalAll


DISTR.HIPERGEOMHYPGEOM.FORDELINGCompatibilityAll


DISTR.HIPERGEOM.NHYPGEOM.FORDELINGStatisticalAll


DISTR.LOG.INVLOGINVCompatibilityAll


DISTR.LOG.NORMLOGNORMFORDCompatibilityAll


DISTR.LOGNORMLOGNORM.FORDELINGStatisticalAll


DISTR.NORMNORMALFORDELINGCompatibilityAll


DISTR.NORM.ESTANDNORMSFORDELINGCompatibilityAll


DISTR.NORM.ESTAND.INVNORMSINVCompatibilityAll


DISTR.NORM.ESTAND.NNORM.S.FORDELINGStatisticalAll


DISTR.NORM.INVNORMINVStatisticalAll


DISTR.NORM.NNORM.FORDELINGStatisticalAll


DISTR.TTFORDELINGCompatibilityAll


DISTR.T.2CT.FORDELING.2TStatisticalAll


DISTR.T.CDT.FORDELING.HStatisticalAll


DISTR.T.INVTINVCompatibilityAll


DISTR.T.NT.FORDELINGStatisticalAll


DISTR.WEIBULLWEIBULL.DIST.NStatisticalAll


DIVIDIRTEXTOTEKSTDELINGText2024


DROPUTELATLookup and reference2024


DURACIONVARIGHETFinancialAll


DURACION.MODIFMVARIGHETFinancialAll


DVSVERDIAVSFinancialAllLearnesy →


ELEGIRVELGLookup and referenceAllLearnesy →


ELEGIRCOLSVELGKOLLookup and reference2024


ELEGIRFILASVELGRADERLookup and reference2024


ENCOLTILKOLLookup and reference2024


ENCONTRARFINNTextAllLearnesy →


ENCONTRARBFINNBTextAll


ENFILATILRADLookup and reference2024


ENTEROHELTALLMath and trigonometryAllLearnesy →


ERROR.TIPICO.XYSTANDARDFEILStatisticalAll


ES.IMPARERODDETALLInformationAll


ES.PARERPARTALLInformationAll


ESBLANCOERTOMInformationAll


ESERRERFInformationAll


ESERRORERFEILInformationAll


ESFORMULAERFORMELInformationAll


ESLOGICOERLOGISKInformationAll


ESNODERITInformationAll


ESNOTEXTOERIKKETEKSTInformationAll


ESNUMEROERTALLInformationAll


ESPACIOSTRIMMETextAllLearnesy →


ESREFERREFInformationAll


ESTEXTOERTEKSTInformationAll


ESTIMACION.LINEALRETTLINJEStatisticalAll


ESTIMACION.LOGARITMICAKURVEStatisticalAll


EUROCONVERTEUROKONVERTERINGAdd-in and AutomationAll


EXPEKSPMath and trigonometryAll


EXPANDIRUTVIDLookup and reference2024


EXTRAEDELTEKSTTextAllLearnesy →


EXTRAEBDELTEKSTBTextAll


FACTFAKULTETMath and trigonometryAll


FACT.DOBLEDOBBELFAKTMath and trigonometryAll


FALSOUSANNLogicalAll


FECHADATODate and timeAllLearnesy →


FECHA.MESDAG.ETTERDate and timeAll


FECHANUMERODATOVERDIDate and timeAll


FIPHIStatisticalAll


FILARADLookup and referenceAll


FILASRADERLookup and referenceAll


FILTRARFILTRERELookup and reference2021


FIN.MESMÅNEDSSLUTTDate and timeAllLearnesy →


FISHERFISHERStatisticalAll


FONETICOFURIGANATextAll


FORMULATEXTOFORMELTEKSTLookup and referenceAll


FRAC.AÑOÅRDELDate and timeAll


FRECUENCIAFREKVENSStatisticalAll


FUN.ERRORFEILFEngineeringAll


FUN.ERROR.COMPLFEILFKEngineeringAll


FUN.ERROR.COMPL.EXACTOFEILFK.PRESISEngineeringAll


FUN.ERROR.EXACTOFEILF.PRESISEngineeringAll


GAMMAGAMMAStatisticalAll


GAMMA.LNGAMMALNStatisticalAll


GAMMA.LN.EXACTOGAMMALN.PRESISStatisticalAll


GAUSSGAUSSStatisticalAll


GRADOSGRADERMath and trigonometryAll


HALLARSØKTextAllLearnesy →


HALLARBSØKBTextAll


HEX.A.BINHEKSTILBINEngineeringAll


HEX.A.DECHEKSTILDESEngineeringAll


HEX.A.OCTHEKSTILOKTEngineeringAll


HIPERVINCULOHYPERKOBLINGLookup and referenceAll


HISTORIALCOTIZACIONESAKSJEHISTORIKKInformationAll


HOJAARKInformationAll


HOJASANTALL.ARKInformationAll


HORATIMEDate and timeAll


HORANUMEROTIDSVERDIDate and timeAll


HOYIDAGDate and timeAll


ID.REGISTROREGISTRER.IDAdd-in and AutomationAll


IGUALEKSAKTTextAllLearnesy →


IM.ABSIMABSEngineeringAll


IM.ANGULOIMARGUMENTEngineeringAll


IM.CONJUGADAIMKONJUGERTEngineeringAll


IM.COSIMCOSEngineeringAll


IM.COSHIMCOSHEngineeringAll


IM.COTIMCOTEngineeringAll


IM.CSCIMCSCEngineeringAll


IM.CSCHIMCSCHEngineeringAll


IM.DIVIMDIVEngineeringAll


IM.EXPIMEKSPEngineeringAll


IM.LNIMLNEngineeringAll


IM.LOG10IMLOG10EngineeringAll


IM.LOG2IMLOG2EngineeringAll


IM.POTIMOPPHØYEngineeringAll


IM.PRODUCTIMPRODUKTEngineeringAll


IM.RAIZ2IMROTEngineeringAll


IM.REALIMREELLEngineeringAll


IM.SECIMSECEngineeringAll


IM.SECHIMSECHEngineeringAll


IM.SENOIMSINEngineeringAll


IM.SENOHIMSINHEngineeringAll


IM.SUMIMSUMMEREngineeringAll


IM.SUSTRIMSUBEngineeringAll


IM.TANIMTANEngineeringAll


IMAGENBILDELookup and reference2024


IMAGINARIOIMAGINÆREngineeringAll


IMPORTARDATOSDINAMICOSHENTPIVOTDATALookup and referenceAll


INDICEINDEKSLookup and referenceAllLearnesy →


INDIRECTOINDIREKTELookup and referenceAllLearnesy →


INFOINFOInformationAll


INT.ACUMPÅLØPT.PERIODISK.RENTEFinancialAll


INT.ACUM.VPÅLØPT.FORFALLSRENTEFinancialAll


INT.EFECTIVOEFFEKTIV.RENTEFinancialAll


INT.PAGO.DIRER.AVDRAGFinancialAll


INTERSECCION.EJESKJÆRINGSPUNKTStatisticalAll


INTERVALO.CONFIANZAKONFIDENSCompatibilityAll


INTERVALO.CONFIANZA.NORMKONFIDENS.NORMStatisticalAll


INTERVALO.CONFIANZA.TKONFIDENS.TStatisticalAll


INV.BINOMBINOM.INVStatisticalAll


INV.CHICUADKJIKVADRAT.INVStatisticalAll


INV.CHICUAD.CDKJIKVADRAT.INV.HStatisticalAll


INV.FF.INVStatisticalAll


INV.F.CDF.INV.HStatisticalAll


INV.GAMMAGAMMA.INVStatisticalAll


INV.LOGNORMLOGNORM.INVStatisticalAll


INV.NORMNORM.INVCompatibilityAll


INV.NORM.ESTANDNORM.S.INVStatisticalAll


INV.TT.INVStatisticalAll


INV.T.2CT.INV.2TStatisticalAll


ISO.NUM.DE.SEMANAISOUKENRDate and timeAll


ISOMITTEDISOMITTEDInformation2024


IZQUIERDAVENSTRETextAllLearnesy →


IZQUIERDABVENSTREBTextAll


JERARQUIARANGCompatibilityAllLearnesy →


JERARQUIA.EQVRANG.EKVStatisticalAll


JERARQUIA.MEDIARANG.GJSNStatisticalAll


K.ESIMO.MAYORN.STØRSTStatisticalAllLearnesy →


K.ESIMO.MENORN.MINSTStatisticalAllLearnesy →


LAMBDALAMBDALogical2024


LARGOLENGDETextAllLearnesy →


LARGOBLENGDEBTextAll


LETLETLogical2021


LETRA.DE.TES.PRECIOTBILLPRISFinancialAll


LETRA.DE.TES.RENDTOTBILLAVKASTNINGFinancialAll


LETRA.DE.TEST.EQV.A.BONOTBILLEKVFinancialAll


LIMPIARRENSKTextAllLearnesy →


LLAMARANROPAdd-in and AutomationAll


LNLNMath and trigonometryAll


LOGLOGMath and trigonometryAll


LOG10LOG10Math and trigonometryAll


M.C.DSFFMath and trigonometryAll


M.C.MMFMMath and trigonometryAll


M.UNIDADMENHETMath and trigonometryAll


MAKEARRAYMAKEARRAYLogical2024


MAPKARTLogical2024


MATRIZALEATTILFELDIGMATRISEMath and trigonometry2021


MATRIZATEXTOMATRISETILTEKSTText2021


MAXSTØRSTStatisticalAll


MAX.SI.CONJUNTOMAKS.HVIS.SETTStatistical2019


MAXAMAKSAStatisticalAll


MAYOR.O.IGUALGRENSEVERDIEngineeringAll


MAYUSCSTORETextAllLearnesy →


MDETERMMDETERMMath and trigonometryAll


MEDIA.ACOTADATRIMMET.GJENNOMSNITTStatisticalAll


MEDIA.ARMOGJENNOMSNITT.HARMONISKStatisticalAll


MEDIA.GEOMGJENNOMSNITT.GEOMETRISKStatisticalAll


MEDIANAMEDIANStatisticalAllLearnesy →


MESMÅNEDDate and timeAll


MIEMBROCUBOKUBEMEDLEMCubeAll


MIEMBROKPICUBOKUBEKPIMEDLEMCubeAll


MIEMBRORANGOCUBOKUBERANGERTMEDLEMCubeAll


MINMINStatisticalAll


MIN.SI.CONJUNTOMIN.HVIS.SETTStatistical2019


MINAMINAStatisticalAll


MINUSCSMÅTextAllLearnesy →


MINUTOMINUTTDate and timeAll


MINVERSAMINVERSMath and trigonometryAll


MMULTMMULTMath and trigonometryAll


MODAMODUSCompatibilityAllLearnesy →


MODA.UNOMODUS.SNGLStatisticalAll


MODA.VARIOSMODUS.MULTStatisticalAll


MONEDAVALUTATextAll


MONEDA.DECDOLLARDEFinancialAll


MONEDA.FRACDOLLARBRFinancialAll


MULTINOMIALMULTINOMINELLMath and trigonometryAll


MULTIPLO.INFERIORAVRUND.GJELDENDE.MULTIPLUM.NEDCompatibilityAll


MULTIPLO.INFERIOR.EXACTOAVRUND.GJELDENDE.MULTIPLUM.NED.PRESISMath and trigonometryAll


MULTIPLO.INFERIOR.MATAVRUND.GJELDENDE.MULTIPLUM.NED.MATEMATISKMath and trigonometryAll


MULTIPLO.SUPERIORAVRUND.GJELDENDE.MULTIPLUMCompatibilityAll


MULTIPLO.SUPERIOR.EXACTOAVRUND.GJELDENDE.MULTIPLUM.PRESISMath and trigonometryAll


MULTIPLO.SUPERIOR.ISOISO.AVRUND.GJELDENDE.MULTIPLUMMath and trigonometryAll


MULTIPLO.SUPERIOR.MATAVRUND.GJELDENDE.MULTIPLUM.OPP.MATEMATISKMath and trigonometryAll


NNInformationAll


NEGBINOM.DISTNEGBINOM.FORDELINGStatisticalAll


NEGBINOMDISTNEGBINOM.FORDELINGCompatibilityAll


NOIKKELogicalAll


NODITInformationAll


NOMPROPIOSTOR.FORBOKSTAVTextAllLearnesy →


NORMALIZACIONNORMALISERStatisticalAll


NPERPERIODERFinancialAllLearnesy →


NSHORATIDDate and timeAllLearnesy →


NUM.DE.SEMANAUKENRDate and timeAll


NUMERO.ARABEARABISKMath and trigonometryAll


NUMERO.ROMANOROMERTALLMath and trigonometryAll


OELLERLogicalAllLearnesy →


OCT.A.BINOKTTILBINEngineeringAll


OCT.A.DECOKTTILDESEngineeringAll


OCT.A.HEXOKTTILHEKSEngineeringAll


ORDENARSORTERLookup and reference2021


ORDENARPORSORTER.ETTERLookup and reference2021


P.DURACIONPVARIGHETFinancialAll


PAGOAVDRAGFinancialAllLearnesy →


PAGO.INT.ENTRESAMLET.RENTEFinancialAll


PAGO.PRINC.ENTRESAMLET.HOVEDSTOLFinancialAll


PAGOINTRAVDRAGFinancialAllLearnesy →


PAGOPRINAMORTFinancialAllLearnesy →


PEARSONPEARSONStatisticalAll


PENDIENTESTIGNINGSTALLStatisticalAll


PERCENTILPERSENTILCompatibilityAllLearnesy →


PERCENTIL.EXCPERSENTIL.EKSStatisticalAll


PERCENTIL.INCPERSENTIL.INKStatisticalAll


PERCENTOFPROSENTAVMath and trigonometry365


PERMUTACIONESPERMUTERStatisticalAll


PERMUTACIONES.APERMUTASJONAStatisticalAll


PIPIMath and trigonometryAll


PIVOTARPORPIVOTBYLookup and reference365


POISSONPOISSONCompatibilityAll


POISSON.DISTPOISSON.FORDELINGStatisticalAll


POTENCIAOPPHØYD.IMath and trigonometryAll


PRECIOPRISFinancialAll


PRECIO.DESCUENTOPRIS.DISKONTERTFinancialAll


PRECIO.PER.IRREGULAR.1AVVIKFP.PRISFinancialAll


PRECIO.PER.IRREGULAR.2AVVIKSP.PRISFinancialAll


PRECIO.VENCIMIENTOPRIS.FORFALLFinancialAll


PROBABILIDADSANNSYNLIGStatisticalAll


PRODUCTOPRODUKTMath and trigonometryAll


PROMEDIOGJENNOMSNITTStatisticalAllLearnesy →


PROMEDIO.SIGJENNOMSNITTHVISStatisticalAllLearnesy →


PROMEDIO.SI.CONJUNTOGJENNOMSNITT.HVIS.SETTStatisticalAll


PROMEDIOAGJENNOMSNITTAStatisticalAll


PRONOSTICOPROGNOSEStatisticalAllLearnesy →


PRONOSTICO.ETSPROGNOSE.ETSStatisticalAll


PRONOSTICO.ETS.CONFINTPROGNOSE.ETS.CONFINTStatisticalAll


PRONOSTICO.ETS.ESTACIONALIDADPROGNOSE.ETS.SESONGAVHENGIGHETStatisticalAll


PRONOSTICO.ETS.STATPROGNOSE.ETS.STATStatisticalAll


PRONOSTICO.LINEALPROGNOSE.LINEÆRStatisticalAll


PROPIEDADMIEMBROCUBOKUBEMEDLEMEGENSKAPCubeAll


PRUEBA.CHIKJI.TESTCompatibilityAll


PRUEBA.CHI.INVINVERS.KJI.FORDELINGCompatibilityAll


PRUEBA.CHICUADKJIKVADRAT.TESTStatisticalAll


PRUEBA.FFTESTCompatibilityAll


PRUEBA.F.NF.TESTStatisticalAll


PRUEBA.FISHER.INVFISHERINVStatisticalAll


PRUEBA.TTTESTCompatibilityAll


PRUEBA.T.NT.TESTStatisticalAll


PRUEBA.ZZTESTCompatibilityAll


PRUEBA.Z.NZ.TESTStatisticalAll


RADIANESRADIANERMath and trigonometryAll


RAIZROTMath and trigonometryAll


RAIZ2PIROTPIMath and trigonometryAll


RANGO.PERCENTILPROSENTDELCompatibilityAll


RANGO.PERCENTIL.EXCPROSENTDEL.EKSStatisticalAll


RANGO.PERCENTIL.INCPROSENTDEL.INKStatisticalAll


RDTRRTDLookup and referenceAll


RECORTAR.RANGOTRIMRANGELookup and reference365


RECUENTOCONJUNTOCUBOKUBESETTANTALLCubeAll


REDOND.MULTMRUNDMath and trigonometryAll


REDONDEA.IMPARAVRUND.TIL.ODDETALLMath and trigonometryAllLearnesy →


REDONDEA.PARAVRUND.TIL.PARTALLMath and trigonometryAllLearnesy →


REDONDEARAVRUNDMath and trigonometryAllLearnesy →


REDONDEAR.MASAVRUND.OPPMath and trigonometryAllLearnesy →


REDONDEAR.MENOSAVRUND.NEDMath and trigonometryAllLearnesy →


REDUCEREDUCELogical2024


REEMPLAZARERSTATTTextAllLearnesy →


REEMPLAZARBERSTATTBTextAll


REGEXEXTRACTREGEXEXTRACTText365


REGEXREPLACEREGEXREPLACEText365


REGEXTESTREGEXTESTText365


RENDTOAVKASTFinancialAll


RENDTO.DESCAVKAST.DISKONTERTFinancialAll


RENDTO.PER.IRREGULAR.1AVVIKFP.AVKASTNINGFinancialAll


RENDTO.PER.IRREGULAR.2AVVIKSP.AVKASTNINGFinancialAll


RENDTO.VENCTOAVKAST.FORFALLFinancialAll


REPETIRGJENTATextAll


RESIDUORESTMath and trigonometryAll


RRIREALISERT.AVKASTNINGFinancialAll


SCANSCANLogical2024


SECSECMath and trigonometryAll


SECHSECHMath and trigonometryAll


SECUENCIASEKVENSMath and trigonometry2021


SEGUNDOSEKUNDDate and timeAll


SENOSINMath and trigonometryAll


SENOHSINHMath and trigonometryAll


SERVICIOWEBNETTJENESTEWebAll


SIHVISLogicalAllLearnesy →


SI.CONJUNTOHVIS.SETTLogical2019


SI.ERRORHVISFEILLogicalAllLearnesy →


SI.NDHVIS.ITLogicalAll


SIFECHADATEDIFDate and timeAllLearnesy →


SIGNOFORTEGNMath and trigonometryAll


SLNLINAVSFinancialAllLearnesy →


SUBTOTALESDELSUMMath and trigonometryAll


SUMASUMMERMath and trigonometryAllLearnesy →


SUMA.CUADRADOSSUMMERKVADRATMath and trigonometryAll


SUMA.SERIESSUMMER.REKKEMath and trigonometryAll


SUMAPRODUCTOSUMMERPRODUKTMath and trigonometryAllLearnesy →


SUMAR.SISUMMERHVISMath and trigonometryAllLearnesy →


SUMAR.SI.CONJUNTOSUMMER.HVIS.SETTMath and trigonometryAllLearnesy →


SUMAX2MASY2SUMMERX2PY2Math and trigonometryAll


SUMAX2MENOSY2SUMMERX2MY2Math and trigonometryAll


SUMAXMENOSY2SUMMERXMY2Math and trigonometryAll


SUSTITUIRBYTT.UTTextAllLearnesy →


SYDÅRSAVSFinancialAllLearnesy →


TTTextAll


TANTANMath and trigonometryAll


TANHTANHMath and trigonometryAll


TASARENTEFinancialAllLearnesy →


TASA.DESCDISKONTERTFinancialAll


TASA.INTRENTESATSFinancialAll


TASA.NOMINALNOMINELLFinancialAll


TENDENCIATRENDStatisticalAll


TEXTOTEKSTTextAll


TEXTOANTESTEKSTFØRText2024


TEXTOBAHTBAHTTEKSTTextAll


TEXTODESPUESTEKSTETTERText2024


TIPOVERDITYPEInformationAll


TIPO.DE.ERRORFEIL.TYPEInformationAll


TIRIRFinancialAllLearnesy →


TIR.NO.PERXIRFinancialAll


TIRMMODIRFinancialAll


TOMARTALookup and reference2024


TRADUCIROVERSETTText365


TRANSPONERTRANSPONERLookup and referenceAll


TRUNCARAVKORTMath and trigonometryAllLearnesy →


UNICARUNICODETEGNTextAll


UNICODEUNICODETextAll


UNICOSUNIKLookup and reference2021


UNIRCADENASTEKST.KOMBINERText2019


URLCODIFENCODEURLWebAll


VANÅVERDIFinancialAllLearnesy →


VALORVERDITextAll


VALOR.NUMEROTALLVERDITextAll


VALORATEXTOVERDITILTEKSTText2021


VALORCUBOKUBEVERDICubeAll


VARVARIANSCompatibilityAll


VAR.PVARIANS.PStatisticalAll


VAR.SVARIANS.SStatisticalAll


VARAVARIANSAStatisticalAll


VARPVARIANSPCompatibilityAll


VARPAVARIANSPAStatisticalAll


VERDADEROSANNLogicalAll


VFSLUTTVERDIFinancialAllLearnesy →


VF.PLANSVPLANFinancialAll


VNANNVFinancialAllLearnesy →


VNA.NO.PERXNNVFinancialAll


XMLFILTROFILTRERXMLWebAll


XOEKSKLUSIVELLERLogicalAll


YOGLogicalAllLearnesy →


          
        

      

    


    


    

      
Common error values in Excel

      

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

      

        

          
            

              Spanish
              Norwegian
              What it means – and the most common cause
            

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

            
#¡VALOR!#VERDI!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?#NAVN?Excel doesn't recognise a name. Most common: a misspelled function name, text without quotes, or a named range that doesn't exist.

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

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

            
#¡DESBORDAMIENTO!#SØL!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.