translateformula.com
All language pairs

Translate Excel formulas between French 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.
          
            

              French
              Norwegian
              Category
              Version
              Learn more
            

          
          



ABSABSMath and trigonometryAll


ACOSARCCOSMath and trigonometryAll


ACOSHARCCOSHMath and trigonometryAll


ACOTACOTMath and trigonometryAll


ACOTHACOTHMath and trigonometryAll


ADRESSEADRESSELookup and referenceAll


AGREGATMENGDEMath and trigonometryAll


ALEATILFELDIGMath and trigonometryAllLearnesy →


ALEA.ENTRE.BORNESTILFELDIGMELLOMMath and trigonometryAllLearnesy →


AMORDEGRCAMORDEGRCFinancialAll


AMORLINLINAVSFinancialAllLearnesy →


AMORLINCAMORLINCFinancialAll


ANNEEÅRDate and timeAll


ARRONDIAVRUNDMath and trigonometryAllLearnesy →


ARRONDI.AU.MULTIPLEMRUNDMath and trigonometryAll


ARRONDI.INFAVRUND.NEDMath and trigonometryAllLearnesy →


ARRONDI.SUPAVRUND.OPPMath and trigonometryAllLearnesy →


ASCSTIGENDETextAll


ASINARCSINMath and trigonometryAll


ASINHARCSINHMath and trigonometryAll


ASSEMB.HHSTAKKLookup and reference2024


ASSEMB.VVSTAKKLookup and reference2024


ATANARCTANMath and trigonometryAll


ATAN2ARCTAN2Math and trigonometryAll


ATANHARCTANHMath and trigonometryAll


AUJOURDHUIIDAGDate and timeAll


AVERAGEAGJENNOMSNITTAStatisticalAll


BAHTTEXTBAHTTEKSTTextAll


BASEGRUNNTALLMath and trigonometryAll


BDECARTYPEDSTDAVDatabaseAll


BDECARTYPEPDSTAVPDatabaseAll


BDLIREDHENTDatabaseAll


BDMAXDSTØRSTDatabaseAll


BDMINDMINDatabaseAll


BDMOYENNEDGJENNOMSNITTDatabaseAll


BDNBDANTALLDatabaseAll


BDNBVALDANTALLADatabaseAll


BDPRODUITDPRODUKTDatabaseAll


BDSOMMEDSUMMERDatabaseAll


BDVARDVARIANSDatabaseAll


BDVARPDVARIANSPDatabaseAll


BESSELIBESSELIEngineeringAll


BESSELJBESSELJEngineeringAll


BESSELKBESSELKEngineeringAll


BESSELYBESSELYEngineeringAll


BETA.INVERSEINVERS.BETA.FORDELINGCompatibilityAll


BETA.INVERSE.NBETA.INVStatisticalAll


BINDECBINTILDESEngineeringAll


BINHEXBINTILHEKSEngineeringAll


BINOCTBINTILOKTEngineeringAll


BITDECALDBITHFORSKYVEngineeringAll


BITDECALGBITVFORSKYVEngineeringAll


BITETBITOGEngineeringAll


BITOUBITELLEREngineeringAll


BITOUEXCLUSIFBITEKSKLUSIVELLEREngineeringAll


BYCOLETTERKOLLogical2024


BYROWETTERRADLogical2024


CARTEGNKODETextAll


CARTEKARTLogical2024


CELLULECELLEInformationAll


CENTILEPERSENTILCompatibilityAllLearnesy →


CENTILE.EXCLUREPERSENTIL.EKSStatisticalAll


CENTILE.INCLUREPERSENTIL.INKStatisticalAll


CENTREE.REDUITENORMALISERStatisticalAll


CHERCHESØKTextAllLearnesy →


CHERCHERBSØKBTextAll


CHIFFRE.ARABEARABISKMath and trigonometryAll


CHISQ.TESTKJIKVADRAT.TESTStatisticalAll


CHOISIRVELGLookup and referenceAllLearnesy →


CHOISIRCOLSVELGKOLLookup and reference2024


CHOISIRLIGNESVELGRADERLookup and reference2024


CNUMVERDITextAll


CODEKODETextAll


COEFFICIENT.ASYMETRIESKJEVFORDELINGStatisticalAll


COEFFICIENT.ASYMETRIE.PSKJEVFORDELING.PStatisticalAll


COEFFICIENT.CORRELATIONKORRELASJONStatisticalAll


COEFFICIENT.DETERMINATIONRKVADRATStatisticalAll


COLONNEKOLONNELookup and referenceAll


COLONNESKOLONNERLookup and referenceAll


COMBINKOMBINASJONMath and trigonometryAll


COMBINAKOMBINASJONAMath and trigonometryAll


COMPLEXEKOMPLEKSEngineeringAll


COMPLEXE.ARGUMENTIMARGUMENTEngineeringAll


COMPLEXE.CONJUGUEIMKONJUGERTEngineeringAll


COMPLEXE.COSIMCOSEngineeringAll


COMPLEXE.COSHIMCOSHEngineeringAll


COMPLEXE.COTIMCOTEngineeringAll


COMPLEXE.CSCIMCSCEngineeringAll


COMPLEXE.CSCHIMCSCHEngineeringAll


COMPLEXE.DIFFERENCEIMSUBEngineeringAll


COMPLEXE.DIVIMDIVEngineeringAll


COMPLEXE.EXPIMEKSPEngineeringAll


COMPLEXE.IMAGINAIREIMAGINÆREngineeringAll


COMPLEXE.LNIMLNEngineeringAll


COMPLEXE.LOG10IMLOG10EngineeringAll


COMPLEXE.LOG2IMLOG2EngineeringAll


COMPLEXE.MODULEIMABSEngineeringAll


COMPLEXE.PRODUITIMPRODUKTEngineeringAll


COMPLEXE.PUISSANCEIMOPPHØYEngineeringAll


COMPLEXE.RACINEIMROTEngineeringAll


COMPLEXE.REELIMREELLEngineeringAll


COMPLEXE.SECIMSECEngineeringAll


COMPLEXE.SECHIMSECHEngineeringAll


COMPLEXE.SINIMSINEngineeringAll


COMPLEXE.SINHIMSINHEngineeringAll


COMPLEXE.SOMMEIMSUMMEREngineeringAll


COMPLEXE.TANIMTANEngineeringAll


CONCATKJED.SAMMENText2019


CONCATENERKJEDE.SAMMENTextAll


CONVERTKONVERTEREngineeringAll


COSCOSMath and trigonometryAll


COSHCOSHMath and trigonometryAll


COTCOTMath and trigonometryAll


COTHCOTHMath and trigonometryAll


COVARIANCEKOVARIANSCompatibilityAll


COVARIANCE.PEARSONKOVARIANS.PStatisticalAll


COVARIANCE.STANDARDKOVARIANS.SStatisticalAll


CRITERE.LOI.BINOMIALEGRENSE.BINOMCompatibilityAll


CROISSANCEVEKSTStatisticalAll


CSCCSCMath and trigonometryAll


CSCHCSCHMath and trigonometryAll


CTXTFASTSATTTextAll


CUMUL.INTERSAMLET.RENTEFinancialAll


CUMUL.PRINCPERSAMLET.HOVEDSTOLFinancialAll


DANSCOLTILKOLLookup and reference2024


DANSLIGNETILRADLookup and reference2024


DATEDATODate and timeAllLearnesy →


DATE.COUPON.PRECOBLIG.DAG.FORRIGEFinancialAll


DATE.COUPON.SUIVOBLIG.DAGER.EFFinancialAll


DATEDIFDATEDIFDate and timeAllLearnesy →


DATEVALDATOVERDIDate and timeAll


DBDAVSKRFinancialAllLearnesy →


DBCSDBCSTextAll


DBCSJISTextAll


DDBDEGRAVSFinancialAllLearnesy →


DECALERFORSKYVNINGLookup and referenceAllLearnesy →


DECBINDESTILBINEngineeringAll


DECHEXDESTILHEKSEngineeringAll


DECIMALDESIMALMath and trigonometryAll


DECOCTDESTILOKTEngineeringAll


DEGRESGRADERMath and trigonometryAll


DELTADELTAEngineeringAll


DETECTLANGUAGEDETECTLANGUAGEText365


DETERMATMDETERMMath and trigonometryAll


DEVISEVALUTATextAll


DROITEHØYRETextAllLearnesy →


DROITEBHØYREBTextAll


DROITEREGRETTLINJEStatisticalAll


DROPUTELATLookup and reference2024


DUREEVARIGHETFinancialAll


DUREE.MODIFIEEMVARIGHETFinancialAll


ECART.MOYENGJENNOMSNITTSAVVIKStatisticalAll


ECARTYPESTDAVCompatibilityAllLearnesy →


ECARTYPE.PEARSONSTDAV.PStatisticalAll


ECARTYPE.STANDARDSTDAV.SStatisticalAll


ECARTYPEPSTDAVPCompatibilityAll


ENTHELTALLMath and trigonometryAllLearnesy →


EPURAGERENSKTextAllLearnesy →


EQUATION.RANGRANG.EKVStatisticalAll


EQUIVSAMMENLIGNELookup and referenceAllLearnesy →


EQUIVXXSAMSVARLookup and reference2021


ERFFEILFEngineeringAll


ERF.PRECISFEILF.PRESISEngineeringAll


ERFCFEILFKEngineeringAll


ERFC.PRECISFEILFK.PRESISEngineeringAll


ERREUR.TYPE.XYSTANDARDFEILStatisticalAll


EST.IMPAIRERODDETALLInformationAll


EST.PAIRERPARTALLInformationAll


ESTERRERFInformationAll


ESTERREURERFEILInformationAll


ESTFORMULEERFORMELInformationAll


ESTLOGIQUEERLOGISKInformationAll


ESTNAERITInformationAll


ESTNONTEXTEERIKKETEKSTInformationAll


ESTNUMERTALLInformationAll


ESTREFERREFInformationAll


ESTTEXTEERTEKSTInformationAll


ESTVIDEERTOMInformationAll


ETOGLogicalAllLearnesy →


EUROCONVERTEUROKONVERTERINGAdd-in and AutomationAll


EXACTEKSAKTTextAllLearnesy →


EXPEKSPMath and trigonometryAll


EXPANDUTVIDLookup and reference2024


F.TESTF.TESTStatisticalAll


FACTFAKULTETMath and trigonometryAll


FACTDOUBLEDOBBELFAKTMath and trigonometryAll


FAUXUSANNLogicalAll


FEUILLEARKInformationAll


FEUILLESANTALL.ARKInformationAll


FILTREFILTRERELookup and reference2021


FILTRE.XMLFILTRERXMLWebAll


FIN.MOISMÅNEDSSLUTTDate and timeAllLearnesy →


FISHERFISHERStatisticalAll


FISHER.INVERSEFISHERINVStatisticalAll


FONCTION.APPELANTEANROPAdd-in and AutomationAll


FORMULETEXTEFORMELTEKSTLookup and referenceAll


FRACTION.ANNEEÅRDELDate and timeAll


FRACTIONNER.TEXTETEKSTDELINGText2024


FREQUENCEFREKVENSStatisticalAll


GAMMAGAMMAStatisticalAll


GAUCHEVENSTRETextAllLearnesy →


GAUCHEBVENSTREBTextAll


GAUSSGAUSSStatisticalAll


GRANDE.VALEURN.STØRSTStatisticalAllLearnesy →


GROUPER.PARGROUPBYLookup and reference365


HEURETIMEDate and timeAll


HEXBINHEKSTILBINEngineeringAll


HEXDECHEKSTILDESEngineeringAll


HEXOCTHEKSTILOKTEngineeringAll


HISTORIQUE.ACTIONSAKSJEHISTORIKKInformationAll


IMAGEBILDELookup and reference2024


IMPAIRAVRUND.TIL.ODDETALLMath and trigonometryAllLearnesy →


INDEXINDEKSLookup and referenceAllLearnesy →


INDIRECTINDIREKTELookup and referenceAllLearnesy →


INFORMATIONSINFOInformationAll


INTERET.ACCPÅLØPT.PERIODISK.RENTEFinancialAll


INTERET.ACC.MATPÅLØPT.FORFALLSRENTEFinancialAll


INTERVALLE.CONFIANCEKONFIDENSCompatibilityAll


INTERVALLE.CONFIANCE.NORMALKONFIDENS.NORMStatisticalAll


INTERVALLE.CONFIANCE.STUDENTKONFIDENS.TStatisticalAll


INTPERRAVDRAGFinancialAllLearnesy →


INVERSE.LOI.FFFORDELING.INVERSCompatibilityAll


INVERSE.LOI.F.DROITEF.INV.HStatisticalAll


INVERSE.LOI.F.NF.INVStatisticalAll


INVERSEMATMINVERSMath and trigonometryAll


ISO.PLAFONDISO.AVRUND.GJELDENDE.MULTIPLUMMath and trigonometryAll


ISOMITTEDISOMITTEDInformation2024


ISPMTER.AVDRAGFinancialAll


JEUCUBEKUBESETTCubeAll


JOINDRE.TEXTETEKST.KOMBINERText2019


JOURDAGDate and timeAll


JOURSDAGERDate and timeAll


JOURS360DAGER360Date and timeAll


JOURSEMUKEDAGDate and timeAllLearnesy →


KHIDEUX.INVERSEINVERS.KJI.FORDELINGCompatibilityAll


KURTOSISKURTStatisticalAll


LAMBDALAMBDALogical2024


LENBLENGDEBTextAll


LETLETLogical2021


LIEN_HYPERTEXTEHYPERKOBLINGLookup and referenceAll


LIGNERADLookup and referenceAll


LIGNESRADERLookup and referenceAll


LIREDONNEESTABCROISDYNAMIQUEHENTPIVOTDATALookup and referenceAll


LNLNMath and trigonometryAll


LNGAMMAGAMMALNStatisticalAll


LNGAMMA.PRECISGAMMALN.PRESISStatisticalAll


LOGLOGMath and trigonometryAll


LOG10LOG10Math and trigonometryAll


LOGREGKURVEStatisticalAll


LOI.BETABETA.FORDELINGCompatibilityAll


LOI.BETA.NBETA.FORDELINGCompatibilityAll


LOI.BINOMIALEBINOM.FORDELINGCompatibilityAll


LOI.BINOMIALE.INVERSEBINOM.INVStatisticalAll


LOI.BINOMIALE.NBINOM.FORDELINGStatisticalAll


LOI.BINOMIALE.NEGNEGBINOM.FORDELINGCompatibilityAll


LOI.BINOMIALE.NEG.NNEGBINOM.FORDELINGStatisticalAll


LOI.BINOMIALE.SERIEBINOM.FORDELING.OMRÅDEStatisticalAll


LOI.EXPONENTIELLEEKSP.FORDELINGCompatibilityAll


LOI.EXPONENTIELLE.NEKSP.FORDELINGStatisticalAll


LOI.FFFORDELINGCompatibilityAll


LOI.F.DROITEF.FORDELING.HStatisticalAll


LOI.F.NF.FORDELINGStatisticalAll


LOI.GAMMAGAMMAFORDELINGCompatibilityAll


LOI.GAMMA.INVERSEGAMMAINVCompatibilityAll


LOI.GAMMA.INVERSE.NGAMMA.INVStatisticalAll


LOI.GAMMA.NGAMMA.FORDELINGStatisticalAll


LOI.HYPERGEOMETRIQUEHYPGEOM.FORDELINGCompatibilityAll


LOI.HYPERGEOMETRIQUE.NHYPGEOM.FORDELINGStatisticalAll


LOI.KHIDEUXKJI.FORDELINGCompatibilityAll


LOI.KHIDEUX.DROITEKJIKVADRAT.FORDELING.HStatisticalAll


LOI.KHIDEUX.INVERSEKJIKVADRAT.INVStatisticalAll


LOI.KHIDEUX.INVERSE.DROITEKJIKVADRAT.INV.HStatisticalAll


LOI.KHIDEUX.NKJIKVADRAT.FORDELINGStatisticalAll


LOI.LOGNORMALELOGNORMFORDCompatibilityAll


LOI.LOGNORMALE.INVERSELOGINVCompatibilityAll


LOI.LOGNORMALE.INVERSE.NLOGNORM.INVStatisticalAll


LOI.LOGNORMALE.NLOGNORM.FORDELINGStatisticalAll


LOI.NORMALENORMALFORDELINGCompatibilityAll


LOI.NORMALE.INVERSENORMINVStatisticalAll


LOI.NORMALE.INVERSE.NNORM.INVCompatibilityAll


LOI.NORMALE.NNORM.FORDELINGStatisticalAll


LOI.NORMALE.STANDARDNORMSFORDELINGCompatibilityAll


LOI.NORMALE.STANDARD.INVERSENORMSINVCompatibilityAll


LOI.NORMALE.STANDARD.INVERSE.NNORM.S.INVStatisticalAll


LOI.NORMALE.STANDARD.NNORM.S.FORDELINGStatisticalAll


LOI.POISSONPOISSONCompatibilityAll


LOI.POISSON.NPOISSON.FORDELINGStatisticalAll


LOI.STUDENTTFORDELINGCompatibilityAll


LOI.STUDENT.BILATERALET.FORDELING.2TStatisticalAll


LOI.STUDENT.DROITET.FORDELING.HStatisticalAll


LOI.STUDENT.INVERSETINVCompatibilityAll


LOI.STUDENT.INVERSE.BILATERALET.INV.2TStatisticalAll


LOI.STUDENT.INVERSE.NT.INVStatisticalAll


LOI.STUDENT.NT.FORDELINGStatisticalAll


LOI.WEIBULLWEIBULL.FORDELINGCompatibilityAll


LOI.WEIBULL.NWEIBULL.DIST.NStatisticalAll


MAINTENANTNÅDate and timeAll


MAJUSCULESTORETextAllLearnesy →


MAKEARRAYMAKEARRAYLogical2024


MATRICE.UNITAIREMENHETMath and trigonometryAll


MAXSTØRSTStatisticalAll


MAX.SIMAKS.HVIS.SETTStatistical2019


MAXAMAKSAStatisticalAll


MEDIANEMEDIANStatisticalAllLearnesy →


MEMBRECUBEKUBEMEDLEMCubeAll


MEMBREKPICUBEKUBEKPIMEDLEMCubeAll


MIDBDELTEKSTBTextAll


MINMINStatisticalAll


MIN.SIMIN.HVIS.SETTStatistical2019


MINAMINAStatisticalAll


MINUSCULESMÅTextAllLearnesy →


MINUTEMINUTTDate and timeAll


MODRESTMath and trigonometryAll


MODEMODUSCompatibilityAllLearnesy →


MODE.MULTIPLEMODUS.MULTStatisticalAll


MODE.SIMPLEMODUS.SNGLStatisticalAll


MOISMÅNEDDate and timeAll


MOIS.DECALERDAG.ETTERDate and timeAll


MOYENNEGJENNOMSNITTStatisticalAllLearnesy →


MOYENNE.GEOMETRIQUEGJENNOMSNITT.GEOMETRISKStatisticalAll


MOYENNE.HARMONIQUEGJENNOMSNITT.HARMONISKStatisticalAll


MOYENNE.RANGRANG.GJSNStatisticalAll


MOYENNE.REDUITETRIMMET.GJENNOMSNITTStatisticalAll


MOYENNE.SIGJENNOMSNITTHVISStatisticalAllLearnesy →


MOYENNE.SI.ENSGJENNOMSNITT.HVIS.SETTStatisticalAll


MULTINOMIALEMULTINOMINELLMath and trigonometryAll


NNInformationAll


NAITInformationAll


NBANTALLStatisticalAllLearnesy →


NB.COUPONSOBLIG.ANTALLFinancialAll


NB.JOURS.COUPON.PRECOBLIG.DAGER.FFFinancialAll


NB.JOURS.COUPON.SUIVOBLIG.DAGER.NFFinancialAll


NB.JOURS.COUPONSOBLIG.DAGERFinancialAll


NB.JOURS.OUVRESNETT.ARBEIDSDAGERDate and timeAllLearnesy →


NB.JOURS.OUVRES.INTLNETT.ARBEIDSDAGER.INTLDate and timeAll


NB.SIANTALL.HVISStatisticalAllLearnesy →


NB.SI.ENSANTALL.HVIS.SETTStatisticalAllLearnesy →


NB.VIDETELLBLANKEStatisticalAllLearnesy →


NBCARLENGDETextAllLearnesy →


NBJEUCUBEKUBESETTANTALLCubeAll


NBVALANTALLAStatisticalAllLearnesy →


NO.SEMAINEUKENRDate and timeAll


NO.SEMAINE.ISOISOUKENRDate and timeAll


NOMPROPRESTOR.FORBOKSTAVTextAllLearnesy →


NONIKKELogicalAll


NPMPERIODERFinancialAllLearnesy →


OCTBINOKTTILBINEngineeringAll


OCTDECOKTTILDESEngineeringAll


OCTHEXOKTTILHEKSEngineeringAll


ORDONNEE.ORIGINESKJÆRINGSPUNKTStatisticalAll


ORGANISERCOLSBRYTKOLLookup and reference2024


ORGANISERLIGNESBRYTRADERLookup and reference2024


OUELLERLogicalAllLearnesy →


OUXEKSKLUSIVELLERLogicalAll


PAIRAVRUND.TIL.PARTALLMath and trigonometryAllLearnesy →


PDUREEPVARIGHETFinancialAll


PEARSONPEARSONStatisticalAll


PENTESTIGNINGSTALLStatisticalAll


PERMUTATIONPERMUTERStatisticalAll


PERMUTATIONAPERMUTASJONAStatisticalAll


PETITE.VALEURN.MINSTStatisticalAllLearnesy →


PGCDSFFMath and trigonometryAll


PHIPHIStatisticalAll


PHONETIQUEFURIGANATextAll


PIPIMath and trigonometryAll


PIVOTER.PARPIVOTBYLookup and reference365


PLAFONDAVRUND.GJELDENDE.MULTIPLUMCompatibilityAll


PLAFOND.MATHAVRUND.GJELDENDE.MULTIPLUM.OPP.MATEMATISKMath and trigonometryAll


PLAFOND.PRECISAVRUND.GJELDENDE.MULTIPLUM.PRESISMath and trigonometryAll


PLANCHERAVRUND.GJELDENDE.MULTIPLUM.NEDCompatibilityAll


PLANCHER.MATHAVRUND.GJELDENDE.MULTIPLUM.NED.MATEMATISKMath and trigonometryAll


PLANCHER.PRECISAVRUND.GJELDENDE.MULTIPLUM.NED.PRESISMath and trigonometryAll


POURCENTAGE.DEPROSENTAVMath and trigonometry365


PPCMMFMMath and trigonometryAll


PRENDRETALookup and reference2024


PREVISIONPROGNOSEStatisticalAllLearnesy →


PREVISION.ETSPROGNOSE.ETSStatisticalAll


PREVISION.ETS.CARACTERESAISONNIERPROGNOSE.ETS.SESONGAVHENGIGHETStatisticalAll


PREVISION.ETS.CONFINTPROGNOSE.ETS.CONFINTStatisticalAll


PREVISION.ETS.STATPROGNOSE.ETS.STATStatisticalAll


PREVISION.LINEAIREPROGNOSE.LINEÆRStatisticalAll


PRINCPERAMORTFinancialAllLearnesy →


PRIX.BON.TRESORTBILLPRISFinancialAll


PRIX.DCOUPON.IRREGAVVIKSP.PRISFinancialAll


PRIX.DECDOLLARDEFinancialAll


PRIX.FRACDOLLARBRFinancialAll


PRIX.PCOUPON.IRREGAVVIKFP.PRISFinancialAll


PRIX.TITREPRISFinancialAll


PRIX.TITRE.ECHEANCEPRIS.FORFALLFinancialAll


PROBABILITESANNSYNLIGStatisticalAll


PRODUITPRODUKTMath and trigonometryAll


PRODUITMATMMULTMath and trigonometryAll


PROPRIETEMEMBRECUBEKUBEMEDLEMEGENSKAPCubeAll


PUISSANCEOPPHØYD.IMath and trigonometryAll


QUARTILEKVARTILCompatibilityAllLearnesy →


QUARTILE.EXCLUREKVARTIL.EKSStatisticalAll


QUARTILE.INCLUREKVARTIL.INKStatisticalAll


QUOTIENTKVOTIENTMath and trigonometryAll


RACINEROTMath and trigonometryAll


RACINE.PIROTPIMath and trigonometryAll


RADIANSRADIANERMath and trigonometryAll


RANGRANGCompatibilityAllLearnesy →


RANG.POURCENTAGEPROSENTDELCompatibilityAll


RANG.POURCENTAGE.EXCLUREPROSENTDEL.EKSStatisticalAll


RANG.POURCENTAGE.INCLUREPROSENTDEL.INKStatisticalAll


RANGMEMBRECUBEKUBERANGERTMEDLEMCubeAll


RECHERCHESLÅ.OPPLookup and referenceAll


RECHERCHEHFINN.KOLONNELookup and referenceAllLearnesy →


RECHERCHEVFINN.RADLookup and referenceAllLearnesy →


RECHERCHEXXOPPSLAGLookup and reference2021Learnesy →


REDUIREREDUCELogical2024


REGEXEXTRACTREGEXEXTRACTText365


REGEXREPLACEREGEXREPLACEText365


REGEXTESTREGEXTESTText365


REGISTRE.NUMEROREGISTRER.IDAdd-in and AutomationAll


REMPLACERERSTATTTextAllLearnesy →


REMPLACERBERSTATTBTextAll


REND.DCOUPON.IRREGAVVIKSP.AVKASTNINGFinancialAll


REND.PCOUPON.IRREGAVVIKFP.AVKASTNINGFinancialAll


RENDEMENT.BON.TRESORTBILLAVKASTNINGFinancialAll


RENDEMENT.SIMPLEAVKAST.DISKONTERTFinancialAll


RENDEMENT.TITREAVKASTFinancialAll


RENDEMENT.TITRE.ECHEANCEAVKAST.FORFALLFinancialAll


REPTGJENTATextAll


ROMAINROMERTALLMath and trigonometryAll


RTDRTDLookup and referenceAll


SCANSCANLogical2024


SECSECMath and trigonometryAll


SECHSECHMath and trigonometryAll


SECONDESEKUNDDate and timeAll


SEQUENCESEKVENSMath and trigonometry2021


SERIE.JOUR.OUVREARBEIDSDAGDate and timeAllLearnesy →


SERIE.JOUR.OUVRE.INTLARBEIDSDAG.INTLDate and timeAll


SERVICEWEBNETTJENESTEWebAll


SIHVISLogicalAllLearnesy →


SI.CONDITIONSHVIS.SETTLogical2019


SI.MULTIPLEBRYTERLogical2019


SI.NON.DISPHVIS.ITLogicalAll


SIERREURHVISFEILLogicalAllLearnesy →


SIGNEFORTEGNMath and trigonometryAll


SINSINMath and trigonometryAll


SINHSINHMath and trigonometryAll


SOMMESUMMERMath and trigonometryAllLearnesy →


SOMME.CARRESSUMMERKVADRATMath and trigonometryAll


SOMME.CARRES.ECARTSAVVIK.KVADRERTStatisticalAll


SOMME.SERIESSUMMER.REKKEMath and trigonometryAll


SOMME.SISUMMERHVISMath and trigonometryAllLearnesy →


SOMME.SI.ENSSUMMER.HVIS.SETTMath and trigonometryAllLearnesy →


SOMME.X2MY2SUMMERX2MY2Math and trigonometryAll


SOMME.X2PY2SUMMERX2PY2Math and trigonometryAll


SOMME.XMY2SUMMERXMY2Math and trigonometryAll


SOMMEPRODSUMMERPRODUKTMath and trigonometryAllLearnesy →


SOUS.TOTALDELSUMMath and trigonometryAll


STDEVASTDAVVIKAStatisticalAll


STDEVPASTDAVVIKPAStatisticalAll


STXTDELTEKSTTextAllLearnesy →


SUBSTITUEBYTT.UTTextAllLearnesy →


SUP.SEUILGRENSEVERDIEngineeringAll


SUPPRESPACETRIMMETextAllLearnesy →


SYDÅRSAVSFinancialAllLearnesy →


TTTextAll


T.TESTT.TESTStatisticalAll


TABLEAU.ALEATTILFELDIGMATRISEMath and trigonometry2021


TABLEAU.EN.TEXTEMATRISETILTEKSTText2021


TANTANMath and trigonometryAll


TANHTANHMath and trigonometryAll


TAUXRENTEFinancialAllLearnesy →


TAUX.EFFECTIFEFFEKTIV.RENTEFinancialAll


TAUX.ESCOMPTEDISKONTERTFinancialAll


TAUX.ESCOMPTE.RTBILLEKVFinancialAll


TAUX.INT.EQUIVREALISERT.AVKASTNINGFinancialAll


TAUX.INTERETRENTESATSFinancialAll


TAUX.NOMINALNOMINELLFinancialAll


TEMPSTIDDate and timeAllLearnesy →


TEMPSVALTIDSVERDIDate and timeAll


TENDANCETRENDStatisticalAll


TEST.FFTESTCompatibilityAll


TEST.KHIDEUXKJI.TESTCompatibilityAll


TEST.STUDENTTTESTCompatibilityAll


TEST.ZZTESTCompatibilityAll


TEXTETEKSTTextAll


TEXTE.APRESTEKSTETTERText2024


TEXTE.AVANTTEKSTFØRText2024


TRADUIREOVERSETTText365


TRANSPOSETRANSPONERLookup and referenceAll


TRIIRFinancialAllLearnesy →


TRI.PAIEMENTSXIRFinancialAll


TRIERSORTERLookup and reference2021


TRIERPARSORTER.ETTERLookup and reference2021


TRIMMODIRFinancialAll


TRIMRANGETRIMRANGELookup and reference365


TRONQUEAVKORTMath and trigonometryAllLearnesy →


TROUVEFINNTextAllLearnesy →


TROUVERBFINNBTextAll


TYPEVERDITYPEInformationAll


TYPE.ERREURFEIL.TYPEInformationAll


UNICARUNICODETEGNTextAll


UNICODEUNICODETextAll


UNIQUEUNIKLookup and reference2021


URLENCODAGEENCODEURLWebAll


VANÅVERDIFinancialAllLearnesy →


VALEUR.EN.TEXTEVERDITILTEKSTText2021


VALEUR.ENCAISSEMENTPRIS.DISKONTERTFinancialAll


VALEUR.NOMINALEMOTTATT.AVKASTFinancialAll


VALEURCUBEKUBEVERDICubeAll


VALEURNOMBRETALLVERDITextAll


VANNNVFinancialAllLearnesy →


VAN.PAIEMENTSXNNVFinancialAll


VARVARIANSCompatibilityAll


VAR.PVARIANSPCompatibilityAll


VAR.P.NVARIANS.PStatisticalAll


VAR.SVARIANS.SStatisticalAll


VARAVARIANSAStatisticalAll


VARPAVARIANSPAStatisticalAll


VCSLUTTVERDIFinancialAllLearnesy →


VC.PAIEMENTSSVPLANFinancialAll


VDBVERDIAVSFinancialAllLearnesy →


VPMAVDRAGFinancialAllLearnesy →


VRAISANNLogicalAll


Z.TESTZ.TESTStatisticalAll


ZONESOMRÅDERLookup and referenceAll


          
        

      

    


    


    

      
Common error values in Excel

      

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

      

        

          
            

              French
              Norwegian
              What it means – and the most common cause
            

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

            
#VALEUR!#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.

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

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

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

            
#PROPAGATION!#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.