translateformula.com
All language pairs

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

          
          



ABSABSMath and trigonometryAll


ACOSARCCOSMath and trigonometryAll


ACOSHARCCOSHMath and trigonometryAll


ACOTARCCOTMath and trigonometryAll


ACOTHARCCOTHMath and trigonometryAll


AGREGARMÄNGDMath and trigonometryAll


AGRUPARPORGROUPBYLookup and reference365


AHORANUDate and timeAll


AJUSTARCOLSWRAPCOLSLookup and reference2024


AJUSTARFILASWRAPROWSLookup and reference2024


ALEATORIOSLUMPMath and trigonometryAllLearnesy →


ALEATORIO.ENTRESLUMP.MELLANMath and trigonometryAllLearnesy →


AMORTIZ.LINAMORLINCFinancialAll


AMORTIZ.PROGREAMORDEGRCFinancialAll


AÑOÅRDate and timeAll


APILARHHSTACKLookup and reference2024


APILARVVSTACKLookup and reference2024


AREASOMRÅDENLookup and referenceAll


ASCASCTextAll


ASENOARCSINMath and trigonometryAll


ASENOHARCSINHMath and trigonometryAll


ATANARCTANMath and trigonometryAll


ATAN2ARCTAN2Math and trigonometryAll


ATANHARCTANHMath and trigonometryAll


BASEBASMath and trigonometryAll


BDCONTARDANTALDatabaseAll


BDCONTARADANTALVDatabaseAll


BDDESVESTDSTDAVDatabaseAll


BDDESVESTPDSTDAVPDatabaseAll


BDEXTRAERDHÄMTADatabaseAll


BDMAXDMAXDatabaseAll


BDMINDMINDatabaseAll


BDPRODUCTODPRODUKTDatabaseAll


BDPROMEDIODMEDELDatabaseAll


BDSUMADSUMMADatabaseAll


BDVARDVARIANSDatabaseAll


BDVARPDVARIANSPDatabaseAll


BESSELIBESSELIEngineeringAll


BESSELJBESSELJEngineeringAll


BESSELKBESSELKEngineeringAll


BESSELYBESSELYEngineeringAll


BIN.A.DECBIN.TILL.DECEngineeringAll


BIN.A.HEXBIN.TILL.HEXEngineeringAll


BIN.A.OCTBIN.TILL.OKTEngineeringAll


BINOM.CRITKRITBINOMCompatibilityAll


BIT.DESPLDCHABITHSKIFTEngineeringAll


BIT.DESPLIZQDABITVSKIFTEngineeringAll


BIT.OBITELLEREngineeringAll


BIT.XOBITXELLEREngineeringAll


BIT.YBITOCHEngineeringAll


BUSCARLETAUPPLookup and referenceAll


BUSCARHLETAKOLUMNLookup and referenceAllLearnesy →


BUSCARVLETARADLookup and referenceAllLearnesy →


BUSCARXXLETAUPPLookup and reference2021Learnesy →


BYCOLBYCOLLogical2024


BYROWBYROWLogical2024


CAMBIARVÄXLALogical2019


CANTIDAD.RECIBIDABELOPPFinancialAll


CARACTERTECKENKODTextAll


CELDACELLInformationAll


COCIENTEKVOTMath and trigonometryAll


CODIGOKODTextAll


COEF.DE.CORRELKORRELStatisticalAllLearnesy →


COEFICIENTE.ASIMETRIASNEDHETStatisticalAll


COEFICIENTE.ASIMETRIA.PSNEDHET.PStatisticalAll


COEFICIENTE.R2RKVStatisticalAll


COINCIDIRPASSALookup and referenceAllLearnesy →


COINCIDIRXXMATCHNINGLookup and reference2021Learnesy →


COLUMNAKOLUMNLookup and referenceAll


COLUMNASKOLUMNERLookup and referenceAll


COMBINAKOMBINAMath and trigonometryAll


COMBINATKOMBINMath and trigonometryAll


COMPLEJOKOMPLEXEngineeringAll


CONCATSAMMANText2019


CONCATENARSAMMANFOGATextAll


CONJUNTOCUBOKUBUPPSÄTTNINGCubeAll


CONTARANTALStatisticalAllLearnesy →


CONTAR.BLANCOANTAL.TOMMAStatisticalAllLearnesy →


CONTAR.SIANTAL.OMStatisticalAllLearnesy →


CONTAR.SI.CONJUNTOANTAL.OMFStatisticalAllLearnesy →


CONTARAANTALVStatisticalAllLearnesy →


CONV.DECIMALDECIMALMath and trigonometryAll


CONVERTIRKONVERTERAEngineeringAll


COSCOSMath and trigonometryAll


COSHCOSHMath and trigonometryAll


COTCOTMath and trigonometryAll


COTHCOTHMath and trigonometryAll


COVARKOVARCompatibilityAll


COVARIANCE.PKOVARIANS.PStatisticalAll


COVARIANZA.MKOVARIANS.SStatisticalAll


CRECIMIENTOEXPTRENDStatisticalAll


CSCCSKMath and trigonometryAll


CSCHCSKHMath and trigonometryAll


CUARTILKVARTILCompatibilityAllLearnesy →


CUARTIL.EXCKVARTIL.EXKStatisticalAll


CUARTIL.INCKVARTIL.INKStatisticalAll


CUPON.DIASKUPDAGBFinancialAll


CUPON.DIAS.L1KUPDAGBBFinancialAll


CUPON.DIAS.L2KUPDAGNKFinancialAll


CUPON.FECHA.L1KUPFKDFinancialAll


CUPON.FECHA.L2KUPNKDFinancialAll


CUPON.NUMKUPANTFinancialAll


CURTOSISTOPPIGHETStatisticalAll


DBDBFinancialAllLearnesy →


DBCSDBCSTextAll


DBCSJISTextAll


DDBDEGAVSKRFinancialAllLearnesy →


DEC.A.BINDEC.TILL.BINEngineeringAll


DEC.A.HEXDEC.TILL.HEXEngineeringAll


DEC.A.OCTDEC.TILL.OKTEngineeringAll


DECIMALFASTTALTextAll


DELTADELTAEngineeringAll


DERECHAHÖGERTextAllLearnesy →


DERECHABHÖGERBTextAll


DESREFFÖRSKJUTNINGLookup and referenceAllLearnesy →


DESVESTSTDAVCompatibilityAllLearnesy →


DESVEST.MSTDAV.SStatisticalAll


DESVEST.PSTDAV.PStatisticalAll


DESVESTASTDEVAStatisticalAll


DESVESTPSTDAVPCompatibilityAll


DESVESTPASTDEVPAStatisticalAll


DESVIA2KVADAVVStatisticalAll


DESVPROMMEDELAVVStatisticalAll


DETECTARIDIOMAIDENTIFIERASPRÅKText365


DIADAGDate and timeAll


DIA.LABARBETSDAGARDate and timeAllLearnesy →


DIA.LAB.INTLARBETSDAGAR.INTDate and timeAll


DIASDAGARDate and timeAll


DIAS.LABNETTOARBETSDAGARDate and timeAllLearnesy →


DIAS.LAB.INTLNETTOARBETSDAGAR.INTLDate and timeAll


DIAS360DAGAR360Date and timeAll


DIASEMVECKODAGDate and timeAllLearnesy →


DIRECCIONADRESSLookup and referenceAll


DIST.WEIBULLWEIBULLCompatibilityAll


DISTR.BETABETAFÖRDCompatibilityAll


DISTR.BETA.INVBETAINVCompatibilityAll


DISTR.BETA.INVBETA.INVStatisticalAll


DISTR.BETA.NBETA.FÖRDCompatibilityAll


DISTR.BINOMBINOMFÖRDCompatibilityAll


DISTR.BINOM.NBINOM.FÖRDStatisticalAll


DISTR.BINOM.SERIEBINOM.FÖRD.INTERVALLStatisticalAll


DISTR.CHICHI2FÖRDCompatibilityAll


DISTR.CHICUADCHISQ.FÖRDStatisticalAll


DISTR.CHICUAD.CDCHISQ.FÖRD.RTStatisticalAll


DISTR.EXPEXPONFÖRDCompatibilityAll


DISTR.EXP.NEXPON.FÖRDStatisticalAll


DISTR.FFFÖRDCompatibilityAll


DISTR.F.CDF.FÖRD.RTStatisticalAll


DISTR.F.INVFINVCompatibilityAll


DISTR.F.NF.FÖRDStatisticalAll


DISTR.GAMMAGAMMAFÖRDCompatibilityAll


DISTR.GAMMA.INVGAMMAINVCompatibilityAll


DISTR.GAMMA.NGAMMA.FÖRDStatisticalAll


DISTR.HIPERGEOMHYPGEOMFÖRDCompatibilityAll


DISTR.HIPERGEOM.NHYPGEOM.FÖRDStatisticalAll


DISTR.LOG.INVLOGINVCompatibilityAll


DISTR.LOG.NORMLOGNORMFÖRDCompatibilityAll


DISTR.LOGNORMLOGNORM.FÖRDStatisticalAll


DISTR.NORMNORMFÖRDCompatibilityAll


DISTR.NORM.ESTANDNORMSFÖRDCompatibilityAll


DISTR.NORM.ESTAND.INVNORMSINVCompatibilityAll


DISTR.NORM.ESTAND.NNORM.S.FÖRDStatisticalAll


DISTR.NORM.INVNORMINVStatisticalAll


DISTR.NORM.NNORM.FÖRDStatisticalAll


DISTR.TTFÖRDCompatibilityAll


DISTR.T.2CT.FÖRD.2TStatisticalAll


DISTR.T.CDT.FÖRD.RTStatisticalAll


DISTR.T.INVTINVCompatibilityAll


DISTR.T.NT.FÖRDStatisticalAll


DISTR.WEIBULLWEIBULL.FÖRDStatisticalAll


DIVIDIRTEXTODELATEXTText2024


DROPDROPLookup and reference2024


DURACIONLÖPTIDFinancialAll


DURACION.MODIFMLÖPTIDFinancialAll


DVSVDEGRAVSKRFinancialAllLearnesy →


ELEGIRVÄLJLookup and referenceAllLearnesy →


ELEGIRCOLSVÄLJKOLLookup and reference2024


ELEGIRFILASVÄLJRADERLookup and reference2024


ENCOLTOCOLLookup and reference2024


ENCONTRARHITTATextAllLearnesy →


ENCONTRARBHITTABTextAll


ENFILATOROWLookup and reference2024


ENTEROHELTALMath and trigonometryAllLearnesy →


ERROR.TIPICO.XYSTDFELYXStatisticalAll


ES.IMPARÄRUDDAInformationAll


ES.PARÄRJÄMNInformationAll


ESBLANCOÄRTOMInformationAll


ESERRÄRFInformationAll


ESERRORÄRFELInformationAll


ESFORMULAÄRFORMELInformationAll


ESLOGICOÄRLOGISKInformationAll


ESNODÄRSAKNADInformationAll


ESNOTEXTOÄREJTEXTInformationAll


ESNUMEROÄRTALInformationAll


ESPACIOSRENSATextAllLearnesy →


ESREFÄRREFInformationAll


ESTEXTOÄRTEXTInformationAll


ESTIMACION.LINEALREGRStatisticalAll


ESTIMACION.LOGARITMICAEXPREGRStatisticalAll


EUROCONVERTEUROCONVERTAdd-in and AutomationAll


EXPEXPMath and trigonometryAll


EXPANDIREXPANDLookup and reference2024


EXTRAEEXTEXTTextAllLearnesy →


EXTRAEBEXTEXTBTextAll


FACTFAKULTETMath and trigonometryAll


FACT.DOBLEDUBBELFAKULTETMath and trigonometryAll


FALSOFALSKTLogicalAll


FECHADATUMDate and timeAllLearnesy →


FECHA.MESEDATUMDate and timeAll


FECHANUMERODATUMVÄRDEDate and timeAll


FIPHIStatisticalAll


FILARADLookup and referenceAll


FILASRADERLookup and referenceAll


FILTRARFILTRERALookup and reference2021Learnesy →


FIN.MESSLUTMÅNADDate and timeAllLearnesy →


FISHERFISHERStatisticalAll


FONETICOPHONETICTextAll


FORMULATEXTOFORMELTEXTLookup and referenceAll


FRAC.AÑOÅRDELDate and timeAll


FRECUENCIAFREKVENSStatisticalAll


FUN.ERRORFELFEngineeringAll


FUN.ERROR.COMPLFELFKEngineeringAll


FUN.ERROR.COMPL.EXACTOFELFK.EXAKTEngineeringAll


FUN.ERROR.EXACTOFELF.EXAKTEngineeringAll


GAMMAGAMMAStatisticalAll


GAMMA.LNGAMMALNStatisticalAll


GAMMA.LN.EXACTOGAMMALN.EXAKTStatisticalAll


GAUSSGAUSSStatisticalAll


GRADOSGRADERMath and trigonometryAll


HALLARSÖKTextAllLearnesy →


HALLARBSÖKBTextAll


HEX.A.BINHEX.TILL.BINEngineeringAll


HEX.A.DECHEX.TILL.DECEngineeringAll


HEX.A.OCTHEX.TILL.OKTEngineeringAll


HIPERVINCULOHYPERLÄNKLookup and referenceAll


HISTORIALCOTIZACIONESAKTIEHISTORIKInformationAll


HOJABLADInformationAll


HOJASANTALBLADInformationAll


HORATIMMEDate and timeAll


HORANUMEROTIDVÄRDEDate and timeAll


HOYIDAGDate and timeAll


ID.REGISTROREGISTRERA.IDAdd-in and AutomationAll


IGUALEXAKTTextAllLearnesy →


IM.ABSIMABSEngineeringAll


IM.ANGULOIMARGUMENTEngineeringAll


IM.CONJUGADAIMKONJUGATEngineeringAll


IM.COSIMCOSEngineeringAll


IM.COSHIMCOSHEngineeringAll


IM.COTIMCOTEngineeringAll


IM.CSCIMCSCEngineeringAll


IM.CSCHIMCSCHEngineeringAll


IM.DIVIMDIVEngineeringAll


IM.EXPIMEUPPHÖJTEngineeringAll


IM.LNIMLNEngineeringAll


IM.LOG10IMLOG10EngineeringAll


IM.LOG2IMLOG2EngineeringAll


IM.POTIMUPPHÖJTEngineeringAll


IM.PRODUCTIMPRODUKTEngineeringAll


IM.RAIZ2IMROTEngineeringAll


IM.REALIMREALEngineeringAll


IM.SECIMSEKEngineeringAll


IM.SECHIMSEKHEngineeringAll


IM.SENOIMSINEngineeringAll


IM.SENOHIMSINHEngineeringAll


IM.SUMIMSUMEngineeringAll


IM.SUSTRIMDIFFEngineeringAll


IM.TANIMTANEngineeringAll


IMAGENBILDLookup and reference2024


IMAGINARIOIMAGINÄREngineeringAll


IMPORTARDATOSDINAMICOSHÄMTA.PIVOTDATALookup and referenceAll


INDICEINDEXLookup and referenceAllLearnesy →


INDIRECTOINDIREKTLookup and referenceAllLearnesy →


INFOINFOInformationAll


INT.ACUMUPPLRÄNTAFinancialAll


INT.ACUM.VUPPLOBLRÄNTAFinancialAll


INT.EFECTIVOEFFRÄNTAFinancialAll


INT.PAGO.DIRRALÅNFinancialAll


INTERSECCION.EJESKÄRNINGSPUNKTStatisticalAll


INTERVALO.CONFIANZAKONFIDENSCompatibilityAll


INTERVALO.CONFIANZA.NORMKONFIDENS.NORMStatisticalAll


INTERVALO.CONFIANZA.TKONFIDENS.TStatisticalAll


INV.BINOMBINOM.INVStatisticalAll


INV.CHICUADCHI2.INVStatisticalAll


INV.CHICUAD.CDCHI2.INV.RTStatisticalAll


INV.FF.INVStatisticalAll


INV.F.CDF.INV.RTStatisticalAll


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.SEMANAISOVECKONRDate and timeAll


ISOMITTEDÄRUTELÄMNATInformation2024


IZQUIERDAVÄNSTERTextAllLearnesy →


IZQUIERDABVÄNSTERBTextAll


JERARQUIARANGCompatibilityAllLearnesy →


JERARQUIA.EQVRANG.EKVStatisticalAll


JERARQUIA.MEDIARANG.AVGStatisticalAll


K.ESIMO.MAYORSTÖRSTAStatisticalAllLearnesy →


K.ESIMO.MENORMINSTAStatisticalAllLearnesy →


LAMBDALAMBDALogical2024


LARGOLÄNGDTextAllLearnesy →


LARGOBLÄNGDBTextAll


LETLETLogical2021


LETRA.DE.TES.PRECIOSSVXPRISFinancialAll


LETRA.DE.TES.RENDTOSSVXRÄNTAFinancialAll


LETRA.DE.TEST.EQV.A.BONOSSVXEKVFinancialAll


LIMPIARSTÄDATextAllLearnesy →


LLAMARANROPAAdd-in and AutomationAll


LNLNMath and trigonometryAll


LOGLOGMath and trigonometryAll


LOG10LOG10Math and trigonometryAll


M.C.DSGDMath and trigonometryAll


M.C.MMGMMath and trigonometryAll


M.UNIDADMENHETMath and trigonometryAll


MAKEARRAYMAKEARRAYLogical2024


MAPMAPLogical2024


MATRIZALEATSLUMPMATRISMath and trigonometry2021Learnesy →


MATRIZATEXTOMATRISTILLTEXTText2021


MAXMAXStatisticalAll


MAX.SI.CONJUNTOMAXIFSStatistical2019


MAXAMAXAStatisticalAll


MAYOR.O.IGUALSLSTEGEngineeringAll


MAYUSCVERSALERTextAllLearnesy →


MDETERMMDETERMMath and trigonometryAll


MEDIA.ACOTADATRIMMEDELStatisticalAll


MEDIA.ARMOHARMMEDELStatisticalAll


MEDIA.GEOMGEOMEDELStatisticalAll


MEDIANAMEDIANStatisticalAllLearnesy →


MESMÅNADDate and timeAll


MIEMBROCUBOKUBMEDLEMCubeAll


MIEMBROKPICUBOKUBKPIMEDLEMCubeAll


MIEMBRORANGOCUBOKUBRANGORDNADMEDLEMCubeAll


MINMINStatisticalAll


MIN.SI.CONJUNTOMINIFSStatistical2019


MINAMINAStatisticalAll


MINUSCGEMENERTextAllLearnesy →


MINUTOMINUTDate and timeAll


MINVERSAMINVERTMath and trigonometryAll


MMULTMMULTMath and trigonometryAll


MODATYPVÄRDECompatibilityAllLearnesy →


MODA.UNOTYPVÄRDE.ETTStatisticalAll


MODA.VARIOSTYPVÄRDE.FLERAStatisticalAll


MONEDAVALUTATextAll


MONEDA.DECDECTALFinancialAll


MONEDA.FRACBRÅKFinancialAll


MULTINOMIALMULTINOMIALMath and trigonometryAll


MULTIPLO.INFERIORRUNDA.NERCompatibilityAll


MULTIPLO.INFERIOR.EXACTORUNDA.NER.EXAKTMath and trigonometryAll


MULTIPLO.INFERIOR.MATRUNDA.NER.MATEMATISKTMath and trigonometryAll


MULTIPLO.SUPERIORRUNDA.UPPCompatibilityAll


MULTIPLO.SUPERIOR.EXACTORUNDA.UPP.EXAKTMath and trigonometryAll


MULTIPLO.SUPERIOR.ISOISO.RUNDA.UPPMath and trigonometryAll


MULTIPLO.SUPERIOR.MATRUNDA.UPP.MATEMATISKTMath and trigonometryAll


NNInformationAll


NEGBINOM.DISTNEGBINOM.FÖRDStatisticalAll


NEGBINOMDISTNEGBINOMFÖRDCompatibilityAll


NOINTELogicalAll


NODSAKNASInformationAll


NOMPROPIOINITIALTextAllLearnesy →


NORMALIZACIONSTANDARDISERAStatisticalAll


NPERPERIODERFinancialAllLearnesy →


NSHORAKLOCKSLAGDate and timeAllLearnesy →


NUM.DE.SEMANAVECKONRDate and timeAll


NUMERO.ARABEARABISKAMath and trigonometryAll


NUMERO.ROMANOROMERSKMath and trigonometryAll


OELLERLogicalAllLearnesy →


OCT.A.BINOKT.TILL.BINEngineeringAll


OCT.A.DECOKT.TILL.DECEngineeringAll


OCT.A.HEXOKT.TILL.HEXEngineeringAll


ORDENARSORTERALookup and reference2021Learnesy →


ORDENARPORSORTERAEFTERLookup and reference2021Learnesy →


P.DURACIONPLÖPTIDFinancialAll


PAGOBETALNINGFinancialAllLearnesy →


PAGO.INT.ENTREKUMRÄNTAFinancialAll


PAGO.PRINC.ENTREKUMPRISFinancialAll


PAGOINTRBETALNINGFinancialAllLearnesy →


PAGOPRINAMORTFinancialAllLearnesy →


PEARSONPEARSONStatisticalAll


PENDIENTELUTNINGStatisticalAll


PERCENTILPERCENTILCompatibilityAllLearnesy →


PERCENTIL.EXCPERCENTIL.EXKStatisticalAll


PERCENTIL.INCPERCENTIL.INKStatisticalAll


PERCENTOFPROCENTAVMath and trigonometry365


PERMUTACIONESPERMUTStatisticalAll


PERMUTACIONES.APERMUTATIONAStatisticalAll


PIPIMath and trigonometryAll


PIVOTARPORPIVOTBYLookup and reference365


POISSONPOISSONCompatibilityAll


POISSON.DISTPOISSON.FÖRDStatisticalAll


POTENCIAUPPHÖJT.TILLMath and trigonometryAll


PRECIOPRISFinancialAll


PRECIO.DESCUENTOPRISDISKFinancialAll


PRECIO.PER.IRREGULAR.1UDDAFPRISFinancialAll


PRECIO.PER.IRREGULAR.2UDDASPRISFinancialAll


PRECIO.VENCIMIENTOPRISFÖRFFinancialAll


PROBABILIDADSANNOLIKHETStatisticalAll


PRODUCTOPRODUKTMath and trigonometryAll


PROMEDIOMEDELStatisticalAllLearnesy →


PROMEDIO.SIMEDEL.OMStatisticalAllLearnesy →


PROMEDIO.SI.CONJUNTOMEDEL.OMFStatisticalAll


PROMEDIOAAVERAGEAStatisticalAll


PRONOSTICOPREDIKTIONStatisticalAllLearnesy →


PRONOSTICO.ETSPROGNOS.ETSStatisticalAll


PRONOSTICO.ETS.CONFINTPROGNOS.ETS.CONFINTStatisticalAll


PRONOSTICO.ETS.ESTACIONALIDADPROGNOS.ETS.SÄSONGSVARIATIONERStatisticalAll


PRONOSTICO.ETS.STATPROGNOS.ETS.STATStatisticalAll


PRONOSTICO.LINEALPROGNOS.LINJÄRStatisticalAll


PROPIEDADMIEMBROCUBOKUBMEDLEMSEGENSKAPCubeAll


PRUEBA.CHICHI2TESTCompatibilityAll


PRUEBA.CHI.INVCHI2INVCompatibilityAll


PRUEBA.CHICUADCHI2.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.PERCENTILPROCENTRANGCompatibilityAll


RANGO.PERCENTIL.EXCPROCENTRANG.EXKStatisticalAll


RANGO.PERCENTIL.INCPROCENTRANG.INKStatisticalAll


RDTRRTDLookup and referenceAll


RECORTAR.RANGOTRIMOMRÅDELookup and reference365


RECUENTOCONJUNTOCUBOKUBUPPSÄTTNINGANTALCubeAll


REDOND.MULTMAVRUNDAMath and trigonometryAll


REDONDEA.IMPARUDDAMath and trigonometryAllLearnesy →


REDONDEA.PARJÄMNMath and trigonometryAllLearnesy →


REDONDEARAVRUNDAMath and trigonometryAllLearnesy →


REDONDEAR.MASAVRUNDA.UPPÅTMath and trigonometryAllLearnesy →


REDONDEAR.MENOSAVRUNDA.NEDÅTMath and trigonometryAllLearnesy →


REDUCEREDUCELogical2024


REEMPLAZARERSÄTTTextAllLearnesy →


REEMPLAZARBERSÄTTBTextAll


REGEXEXTRACTREGEXUTDRAGText365


REGEXREPLACEREGEXERSÄTTText365


REGEXTESTREGEXTESTText365


RENDTONOMAVKFinancialAll


RENDTO.DESCNOMAVKDISKFinancialAll


RENDTO.PER.IRREGULAR.1UDDAFAVKASTNINGFinancialAll


RENDTO.PER.IRREGULAR.2UDDASAVKASTNINGFinancialAll


RENDTO.VENCTONOMAVKFÖRFFinancialAll


REPETIRREPTextAll


RESIDUOMODMath and trigonometryAll


RRIAVKPÅINVESTFinancialAll


SCANSCANLogical2024


SECSEKMath and trigonometryAll


SECHSEKHMath and trigonometryAll


SECUENCIASEKVENSMath and trigonometry2021Learnesy →


SEGUNDOSEKUNDDate and timeAll


SENOSINMath and trigonometryAll


SENOHSINHMath and trigonometryAll


SERVICIOWEBWEBBTJÄNSTWebAll


SIOMLogicalAllLearnesy →


SI.CONJUNTOIFSLogical2019


SI.ERROROMFELLogicalAllLearnesy →


SI.NDOMSAKNASLogicalAll


SIFECHADATEDIFDate and timeAllLearnesy →


SIGNOTECKENMath and trigonometryAll


SLNLINAVSKRFinancialAllLearnesy →


SUBTOTALESDELSUMMAMath and trigonometryAll


SUMASUMMAMath and trigonometryAllLearnesy →


SUMA.CUADRADOSKVADRATSUMMAMath and trigonometryAll


SUMA.SERIESSERIESUMMAMath and trigonometryAll


SUMAPRODUCTOPRODUKTSUMMAMath and trigonometryAllLearnesy →


SUMAR.SISUMMA.OMMath and trigonometryAllLearnesy →


SUMAR.SI.CONJUNTOSUMMA.OMFMath and trigonometryAllLearnesy →


SUMAX2MASY2SUMMAX2PY2Math and trigonometryAll


SUMAX2MENOSY2SUMMAX2MY2Math and trigonometryAll


SUMAXMENOSY2SUMMAXMY2Math and trigonometryAll


SUSTITUIRBYT.UTTextAllLearnesy →


SYDÅRSAVSKRFinancialAllLearnesy →


TTTextAll


TANTANMath and trigonometryAll


TANHTANHMath and trigonometryAll


TASARÄNTAFinancialAllLearnesy →


TASA.DESCDISKFinancialAll


TASA.INTÅRSRÄNTAFinancialAll


TASA.NOMINALNOMRÄNTAFinancialAll


TENDENCIATRENDStatisticalAll


TEXTOTEXTTextAll


TEXTOANTESTEXTFÖREText2024


TEXTOBAHTBAHTTEXTTextAll


TEXTODESPUESTEXTEFTERText2024


TIPOVÄRDETYPInformationAll


TIPO.DE.ERRORFEL.TYPInformationAll


TIRIRFinancialAllLearnesy →


TIR.NO.PERXIRRFinancialAll


TIRMMODIRFinancialAll


TOMARTALookup and reference2024


TRADUCIRÖVERSÄTTText365


TRANSPONERTRANSPONERALookup and referenceAll


TRUNCARAVKORTAMath and trigonometryAllLearnesy →


UNICARUNITECKENKODTextAll


UNICODEUNICODETextAll


UNICOSUNIKLookup and reference2021Learnesy →


UNIRCADENASTEXTJOINText2019


URLCODIFKODAWEBBADRESSWebAll


VANUVÄRDEFinancialAllLearnesy →


VALORTEXTNUMTextAll


VALOR.NUMEROTALVÄRDETextAll


VALORATEXTOVÄRDETILLTEXTText2021


VALORCUBOKUBVÄRDECubeAll


VARVARIANSCompatibilityAll


VAR.PVARIANS.PStatisticalAll


VAR.SVARIANS.SStatisticalAll


VARAVARAStatisticalAll


VARPVARIANSPCompatibilityAll


VARPAVARIANSPAStatisticalAll


VERDADEROSANTLogicalAll


VFSLUTVÄRDEFinancialAllLearnesy →


VF.PLANFÖRRÄNTNINGFinancialAll


VNANETNUVÄRDEFinancialAllLearnesy →


VNA.NO.PERXNUVÄRDEFinancialAll


XMLFILTROFILTRERAXMLWebAll


XOXELLERLogicalAll


YOCHLogicalAllLearnesy →


          
        

      

    


    


    

      
Common error values in Excel

      

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

      

        

          
            

              Spanish
              Swedish
              What it means – and the most common cause
            

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

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

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

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

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

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

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

            
#¡DESBORDAMIENTO!#SPILL!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.