-->

الاكسيل : ترجمة دوال الاكسل من الانجليزية الى الفرنسية Translate English to French

 

بسم الله الرحمن الرحيم

اهلا بكم متابعى موقع عالم الاوفيس

ترجمة دوال الاكسيل من الانجليزية الى الفرنسية

درس جديد وموضوع مهم جدا لكل مستخدمى الاكسيل من المغرب العربى

مشكلة كبيرة تواجة مستخدمى الاكسيل فى المغرب العربى وخصوصا مستخدمى اكسيل بالفرنسية

حيث يواجهون مشكلة فى ترجمة دوال الاكسل من الانجليزية الى الفرنسية والعكس صحيح

ولهذا قمنا بعمل هذا الموضوع حتى يسهل عليهم عملهم فى الاكسيل باللغة الفرنسية

ويكون مرجع لهم للعمل علية فى اى وقت

ويشتمل الملف على :-

دوال  قواعد البيانات

دوال التاريخ والوقت

دوال هندسية

دوال المالية

دوال المعلومات

دوال منطقية

دوال البحث والمراجع

دالات الرياضيات وعلم المثلثات

الدوال الإحصائية

دوال النصية

Functions in English

Functions in French

Description of Function

Excel:DATE AND TIME FUNCTION

DATE

DATE

Returns the serial number of a particular date.

DATEVALUE

DATEVAL

Converts a date in the form of text to a serial number.

DAY

JOUR

Converts a serial number to a day of the month.

DAYS

JOURS

Returns the number of days between two dates (2013).

DAYS360

JOURS360

Calculates the number of days between two dates based on a 360-day year.

EDATE

MOIS.DECALER

Returns the serial number of the date that is the indicated number of months before or after the start date.

EOMONTH

FIN.MOIS

Returns the serial number of the last day of the month before or after a specified number of months.

HOUR

HEURE

Converts a serial number to an hour.

ISOWEEKNUM

NO.SEMAINE.ISO

Returns the number of the ISO week number of the year for a given date (2013).

MINUTE

MINUTE

Converts a serial number to a minute.

MONTH

MOIS

Converts a serial number to a month.

NETWORKDAYS

NB.JOURS.OUVRES

Returns the number of whole workdays between two dates.

NETWORKDAYS.INTL

NB.JOURS.OUVRES.INTL

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.

NOW

MAINTENANT

Returns the serial number of the current date and time.

SECOND

SECONDE

Converts a serial number to a second.

TIME

TEMPS

Returns the serial number of a particular time.

TIMEVALUE

TEMPSVAL

Converts a time in the form of text to a serial number.

TODAY

AUJOURDHUI

Returns the serial number of today's date.

WEEKDAY

JOURSEM

Converts a serial number to a day of the week.

WEEKNUM

NO.SEMAINE

Converts a serial number to a number representing where the week falls numerically with a year.

WORKDAY

SERIE.JOUR.OUVRE

Returns the serial number of the date before or after a specified number of workdays.

WORKDAY.INTL

SERIE.JOUR.OUVRE.INTL

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

YEAR

ANNEE

Converts a serial number to a year.

YEARFRAC

FRACTION.ANNEE

Returns the year fraction representing the number of whole days between start_date and end_date.

 

 

 

CELL

CELLULE

Returns information about the formatting, location, or contents of a cell.

ERROR.TYPE

TYPE.ERREUR

Returns a number corresponding to an error type.

INFO

INFORMATIONS

Returns information about the current operating environment.

ISBLANK

ESTVIDE

Returns TRUE if the value is blank.

ISERR

ESTERR

Returns TRUE if the value is any error value except #N/A.

ISERROR

ESTERREUR

Returns TRUE if the value is any error value.

ISEVEN

EST.PAIR

Returns TRUE if the number is even.

ISFORMULA

ESTFORMULE

Returns TRUE if there is a reference to a cell that contains a formula (2013).

ISLOGICAL

ESTLOGIQUE

Returns TRUE if the value is a logical value.

ISNA

ESTNA

Returns TRUE if the value is the #N/A error value.

ISNONTEXT

ESTNONTEXTE

Returns TRUE if the value is not text.

ISNUMBER

ESTNUM

Returns TRUE if the value is a number.

ISODD

EST.IMPAIR

Returns TRUE if the number is odd.

ISREF

ESTREF

Returns TRUE if the value is a reference.

ISTEXT

ESTTEXTE

Returns TRUE if the value is text.

N

N

Returns a value converted to a number.

NA

NA

Returns the error value #N/A.

SHEET

FEUILLE

Returns the sheet number of the referenced sheet (2013).

SHEETS

FEUILLES

Returns the number of sheets in a reference (2013).

TYPE

TYPE

Returns a number indicating the data type of a value.

Excel:Logical Functions

 

 

 

AND

ET

Returns TRUE if all of its arguments are TRUE.

FALSE

FAUX

Returns the logical value FALSE.

IF

SI

Specifies a logical test to perform.

IFERROR

SIERREUR

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

IFNA

SI.NON.DISP

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression (2013).

IFS

SI.CONDITIONS

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition (2016).

NOT

NON

Reverses the logic of its argument.

OR

OU

Returns TRUE if any argument is TRUE.

SWITCH

SI.MULTIPLE

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned (2016).

TRUE

VRAI

Returns the logical value TRUE.

XOR

OUX

Returns a logical exclusive OR of all arguments (2013).

Excel:Lookup and Reference Functions

ADDRESS

ADRESSE

Returns a reference as text to a single cell in a worksheet.

AREAS

ZONES

Returns the number of areas in a reference.

CHOOSE

CHOISIR

Chooses a value from a list of values.

COLUMN

COLONNE

Returns the column number of a reference.

COLUMNS

COLONNES

Returns the number of columns in a reference.

FIELDVALUE

VALEURCHAMP

Retrieve field data from linked data types like the Stocks or Geography data types (365).

FILTER

FILTRE

Filters a range of data based on criteria (365).

FORMULATEXT

FORMULETEXTE

Returns the formula at the given reference as text (2013).

GETPIVOTDATA

LIREDONNEESTABCROISDYNAMIQUE

Returns data stored in a PivotTable report.

HLOOKUP

RECHERCHEH

Looks in the top row of an array and returns the value of the indicated cell.

HYPERLINK

LIEN_HYPERTEXTE

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

INDEX

INDEX

Uses an index to choose a value from a reference or array.

INDIRECT

INDIRECT

Returns a reference indicated by a text value.

LOOKUP

RECHERCHE

Looks up values in a vector or array.

MATCH

EQUIV

Looks up values in a reference or array.

OFFSET

DECALER

Returns a reference offset from a given reference.

ROW

LIGNE

Returns the row number of a reference.

ROWS

LIGNES

Returns the number of rows in a reference.

RTD

RTD

Retrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).).

SORT

TRIER

Sorts the contents of a range or array (365).

SORTBY

TRIERPAR

Sorts the contents of a range or array based on the values in a corresponding range or array (365).

TRANSPOSE

TRANSPOSE

Returns the transpose of an array.

VLOOKUP

RECHERCHEV

Looks in the first column of an array and moves across the row to return the value of a cell.

UNIQUE

UNIQUE

Returns a list of unique values in a list or range (365).

XLOOKUP

RECHERCHEX

Searches a range or an array, and then returns the item corresponding to the first match it finds (365).

XMATCH

EQUIVX

Searches for a specified item in an array or range of cells, and then returns the item's relative position (365).

Excel:Math and Trigonometry Functions

ABS

ABS

Returns the absolute value of a number.

ACOS

ACOS

Returns the arccosine of a number.

ACOSH

ACOSH

Returns the inverse hyperbolic cosine of a number.

ACOT

ACOT

Returns the arccotangent of a number (2013).

ACOTH

ACOTH

Returns the hyperbolic arccotangent of a number (2013).

AGGREGATE

AGREGAT

Returns an aggregate in a list or database.

ARABIC

ARABE

Converts a Roman number to Arabic, as a number (2013).

ASIN

ASIN

Returns the arcsine of a number.

ASINH

ASINH

Returns the inverse hyperbolic sine of a number.

ATAN

ATAN

Returns the arctangent of a number.

ATAN2

ATAN2

Returns the arctangent from x- and y-coordinates.

ATANH

ATANH

Returns the inverse hyperbolic tangent of a number.

BASE

BASE

Converts a number into a text representation with the given radix (base) (2013).

CEILING

PLAFOND

Rounds a number to the nearest integer or to the nearest multiple of significance.

CEILING.MATH

PLAFOND.MATH

Rounds a number up, to the nearest integer or to the nearest multiple of significance (2013).

CEILING.PRECISE

PLAFOND.PRECIS

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up..

COMBIN

COMBIN

Returns the number of combinations for a given number of objects.

COMBINA

COMBINA

Returns the number of combinations with repetitions for a given number of items (2013).

COS

COS

Returns the cosine of a number.

COSH

COSH

Returns the hyperbolic cosine of a number.

COT

COT

Returns the hyperbolic cosine of a number (2013).

COTH

COTH

Returns the cotangent of an angle (2013).

CSC

CSC

Returns the cosecant of an angle (2013).

CSCH

CSCH

Returns the hyperbolic cosecant of an angle (2013).

DECIMAL

DECIMAL

Converts a text representation of a number in a given base into a decimal number (2013).

DEGREES

DEGRES

Converts radians to degrees.

EVEN

PAIR

Rounds a number up to the nearest even integer.

EXP

EXP

Returns e raised to the power of a given number.

FACT

FACT

Returns the factorial of a number.

FACTDOUBLE

FACTDOUBLE

Returns the double factorial of a number.

FLOOR

PLANCHER

Rounds a number down, toward zero.

FLOOR.MATH

PLANCHER.MATH

Rounds a number down, to the nearest integer or to the nearest multiple of significance (2013).

FLOOR.PRECISE

PLANCHER.PRECIS

Rounds a numer down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down..

GCD

PGCD

Returns the greatest common divisor.

INT

ENT

Rounds a number down to the nearest integer.

LCM

PPCM

Returns the least common multiple.

LN

LN

Returns the natural logarithm of a number.

LOG

LOG

Returns the logarithm of a number to a specified base.

LOG10

LOG10

Returns the base-10 logarithm of a number.

MDETERM

DETERMAT

Returns the matrix determinant of an array.

MINVERSE

INVERSEMAT

Returns the matrix inverse of an array.

MMULT

PRODUITMAT

Returns the matrix product of two arrays.

MOD

MOD

Returns the remainder from division.

MROUND

ARRONDI.AU.MULTIPLE

Returns a number rounded to the desired multiple.

MULTINOMIAL

MULTINOMIALE

Returns the multinomial of a set of numbers.

MUNIT

MATRICE.UNITAIRE

Returns the unit matrix or the specified dimension (2013).

ODD

IMPAIR

Rounds a number up to the nearest odd integer.

PI

PI

Returns the value of pi.

POWER

PUISSANCE

Returns the result of a number raised to a power.

PRODUCT

PRODUIT

Multiplies its arguments.

QUOTIENT

QUOTIENT

Returns the integer portion of a division.

RADIANS

RADIANS

Converts degrees to radians.

RAND

ALEA

Returns a random number between 0 and 1.

RANDARRAY

TABLEAU.ALEAT

Returns an array of random numbers (365).

RANDBETWEEN

ALEA.ENTRE.BORNES

Returns a random number between the numbers you specify.

ROMAN

ROMAIN

Converts an arabic numeral to roman, as text.

ROUND

ARRONDI

Rounds a number to a specified number of digits.

ROUNDDOWN

ARRONDI.INF

Rounds a number down, toward zero.

ROUNDUP

ARRONDI.SUP

Rounds a number up, away from zero.

SEC

SEC

Returns the secant of an angle (2013).

SECH

SECH

Returns the hyperbolic secant of an angle (2013).

SEQUENCE

SEQUENCE

Generate a list of sequential numbers in an array (365).

SERIESSUM

SOMME.SERIES

Returns the sum of a power series based on the formula.

SIGN

SIGNE

Returns the sign of a number.

SIN

SIN

Returns the sine of the given angle.

SINH

SINH

Returns the hyperbolic sine of a number.

SQRT

RACINE

Returns a positive square root.

SQRTPI

RACINE.PI

Returns the square root of (number * pi).

SUBTOTAL

SOUS.TOTAL

Returns a subtotal in a list or database.

SUM

SOMME

Adds its arguments.

SUMIF

SOMME.SI

Adds the cells specified by a given criteria.

SUMIFS

SOMME.SI.ENS

Adds the cells in a range that meet multiple criteria.

SUMPRODUCT

SOMMEPROD

Returns the sum of the products of corresponding array components.

SUMSQ

SOMME.CARRES

Returns the sum of the squares of the arguments.

SUMX2MY2

SOMME.X2MY2

Returns the sum of the difference of squares of corresponding values in two arrays.

SUMX2PY2

SOMME.X2PY2

Returns the sum of the sum of squares of corresponding values in two arrays.

SUMXMY2

SOMME.XMY2

Returns the sum of squares of differences of corresponding values in two arrays.

TAN

TAN

Returns the tangent of a number.

TANH

TANH

Returns the hyperbolic tangent of a number.

TRUNC

TRONQUE

Truncates a number to an integer.

Excel:Statistical Functions

AVEDEV

ECART.MOYEN

Returns the average of the absolute deviations of data points from their mean.

AVERAGE

MOYENNE

Returns the average of its arguments.

AVERAGEA

AVERAGEA

Returns the average of its arguments, including numbers, text, and logical values.

AVERAGEIF

MOYENNE.SI

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

AVERAGEIFS

MOYENNE.SI.ENS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

BETA.DIST

LOI.BETA.N

Returns the beta cumulative distribution function.

BETA.INV

BETA.INVERSE.N

Returns the inverse of the cumulative distribution function for a specified beta distribution.

BINOM.DIST

LOI.BINOMIALE.N

Returns the individual term binomial distribution probability.

BINOM.DIST.RANGE

LOI.BINOMIALE.SERIE

Returns the probability of a trial result using a binomial distribution (2013).

BINOM.INV

LOI.BINOMIALE.INVERSE

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

CHISQ.DIST

LOI.KHIDEUX.N

Returns the cumulative beta probability density function.

CHISQ.DIST.RT

LOI.KHIDEUX.DROITE

Returns the one-tailed probability of the chi-squared distribution.

CHISQ.INV

LOI.KHIDEUX.INVERSE

Returns the cumulative beta probability density function.

CHISQ.INV.RT

LOI.KHIDEUX.INVERSE.DROITE

Returns the inverse of the one-tailed probability of the chi-squared distribution.

CHISQ.TEST

CHISQ.TEST

Returns the test for independence.

CONFIDENCE.NORM

INTERVALLE.CONFIANCE.NORMAL

Returns the confidence interval for a population mean.

CONFIDENCE.T

INTERVALLE.CONFIANCE.STUDENT

Returns the confidence interval for a population mean, using a Student's t distribution.

CORREL

COEFFICIENT.CORRELATION

Returns the correlation coefficient between two data sets.

COUNT

NB

Counts how many numbers are in the list of arguments.

COUNTA

NBVAL

Counts how many values are in the list of arguments.

COUNTBLANK

NB.VIDE

Counts the number of blank cells within a range.

COUNTIF

NB.SI

Counts the number of cells within a range that meet the given criteria.

COUNTIFS

NB.SI.ENS

Counts the number of cells within a range that meet multiple criteria.

COVARIANCE.P

COVARIANCE.PEARSON

Returns covariance, the average of the products of paired deviations.

COVARIANCE.S

COVARIANCE.STANDARD

Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.

DEVSQ

SOMME.CARRES.ECARTS

Returns the sum of squares of deviations.

EXPON.DIST

LOI.EXPONENTIELLE.N

Returns the exponential distribution.

F.DIST

LOI.F.N

Returns the F probability distribution.

F.DIST.RT

LOI.F.DROITE

Returns the F probability distribution.

F.INV

INVERSE.LOI.F.N

Returns the inverse of the F probability distribution.

F.INV.RT

INVERSE.LOI.F.DROITE

Returns the inverse of the F probability distribution.

F.TEST

F.TEST

Returns the result of an F-test.

FISHER

FISHER

Returns the Fisher transformation.

FISHERINV

FISHER.INVERSE

Returns the inverse of the Fisher transformation.

FORECAST

PREVISION

Returns a value along a linear trend.

FORECAST.ETS

PREVISION.ETS

Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm (2016).

FORECAST.ETS.CONFINT

PREVISION.ETS.CONFINT

Returns a confidence interval for the forecast value at the specified target date (2016).

FORECAST.ETS.SEASONALITY

PREVISION.ETS.CARACTERESAISONNIER

Returns the length of the repetitive pattern Excel detects for the specified time series (2016).

FORECAST.ETS.STAT

PREVISION.ETS.STAT

Returns a statistical value as a result of time series forecasting (2016).

FORECAST.LINEAR

PREVISION.LINEAIRE

Returns a future value based on existing values (2016).

FREQUENCY

FREQUENCE

Returns a frequency distribution as a vertical array.

GAMMA

GAMMA

Returns the Gamma function value (2013).

GAMMA.DIST

LOI.GAMMA.N

Returns the gamma distribution.

GAMMA.INV

LOI.GAMMA.INVERSE.N

Returns the inverse of the gamma cumulative distribution.

GAMMALN

LNGAMMA

Returns the natural logarithm of the gamma function, G(x).

GAMMALN.PRECISE

LNGAMMA.PRECIS

Returns the natural logarithm of the gamma function, G(x).

GAUSS

GAUSS

Returns 0.5 less than the standard normal cumulative distribution (2013).

GEOMEAN

MOYENNE.GEOMETRIQUE

Returns the geometric mean.

GROWTH

CROISSANCE

Returns values along an exponential trend.

HARMEAN

MOYENNE.HARMONIQUE

Returns the harmonic mean.

HYPGEOM.DIST

LOI.HYPERGEOMETRIQUE.N

Returns the hypergeometric distribution.

INTERCEPT

ORDONNEE.ORIGINE

Returns the intercept of the linear regression line.

KURT

KURTOSIS

Returns the kurtosis of a data set.

LARGE

GRANDE.VALEUR

Returns the k-th largest value in a data set.

LINEST

DROITEREG

Returns the parameters of a linear trend.

LOGEST

LOGREG

Returns the parameters of an exponential trend.

LOGNORM.DIST

LOI.LOGNORMALE.N

Returns the cumulative lognormal distribution.

LOGNORM.INV

LOI.LOGNORMALE.INVERSE.N

Returns the inverse of the lognormal cumulative distribution.

MAX

MAX

Returns the maximum value in a list of arguments.

MAXA

MAXA

Returns the maximum value in a list of arguments, including numbers, text, and logical values.

MAXIFS

MAX.SI.ENS

Returns the maximum value among cells specified by a given set of conditions or criteria (2019).

MEDIAN

MEDIANE

Returns the median of the given numbers.

MIN

MIN

Returns the minimum value in a list of arguments.

MINA

MINA

Returns the smallest value in a list of arguments, including numbers, text, and logical values.

MINIFS

MIN.SI.ENS

Returns the minimum value among cells specified by a given set of conditions or criteria (2019).

MODE.MULT

MODE.MULTIPLE

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.

MODE.SNGL

MODE.SIMPLE

Returns the most common value in a data set.

NEGBINOM.DIST

LOI.BINOMIALE.NEG.N

Returns the negative binomial distribution.

NORM.DIST

LOI.NORMALE.N

Returns the normal cumulative distribution.

NORM.INV

LOI.NORMALE.INVERSE.N

Returns the inverse of the normal cumulative distribution.

NORM.S.DIST

LOI.NORMALE.STANDARD.N

Returns the standard normal cumulative distribution.

NORM.S.INV

LOI.NORMALE.STANDARD.INVERSE.N

Returns the inverse of the standard normal cumulative distribution.

PEARSON

PEARSON

Returns the Pearson product moment correlation coefficient.

PERCENTILE.EXC

CENTILE.EXCLURE

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive..

PERCENTILE.INC

CENTILE.INCLURE

Returns the k-th percentile of values in a range.

PERCENTRANK.EXC

RANG.POURCENTAGE.EXCLURE

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

PERCENTRANK.INC

RANG.POURCENTAGE.INCLURE

Returns the percentage rank of a value in a data set.

PERMUT

PERMUTATION

Returns the number of permutations for a given number of objects.

PERMUTATIONA

PERMUTATIONA

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (2013).

PHI

PHI

Returns the value of the density function for a standard normal distribution (2013).

POISSON.DIST

LOI.POISSON.N

Returns the Poisson distribution.

PROB

PROBABILITE

Returns the probability that values in a range are between two limits.

QUARTILE.EXC

QUARTILE.EXCLURE

Returns the quartile of the data set, based on percentile values from 0..1, exclusive.

QUARTILE.INC

QUARTILE.INCLURE

Returns the quartile of a data set.

RANK.AVG

MOYENNE.RANG

Returns the rank of a number in a list of numbers.

RANK.EQ

EQUATION.RANG

Returns the rank of a number in a list of numbers.

RSQ

COEFFICIENT.DETERMINATION

Returns the square of the Pearson product moment correlation coefficient.

SKEW

COEFFICIENT.ASYMETRIE

Returns the skewness of a distribution.

SKEW.P

COEFFICIENT.ASYMETRIE.P

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean (2013).

SLOPE

PENTE

Returns the slope of the linear regression line.

SMALL

PETITE.VALEUR

Returns the k-th smallest value in a data set.

STANDARDIZE

CENTREE.REDUITE

Returns a normalized value.

STDEV.P

ECARTYPE.PEARSON

Calculates standard deviation based on the entire population.

STDEV.S

ECARTYPE.STANDARD

Estimates standard deviation based on a sample.

STDEVA

STDEVA

Estimates standard deviation based on a sample, including numbers, text, and logical values.

STDEVPA

STDEVPA

Calculates standard deviation based on the entire population, including numbers, text, and logical values.

STEYX

ERREUR.TYPE.XY

Returns the standard error of the predicted y-value for each x in the regression.

T.DIST

LOI.STUDENT.N

Returns the Percentage Points (probability) for the Student t-distribution.

T.DIST.2T

LOI.STUDENT.BILATERALE

Returns the Percentage Points (probability) for the Student t-distribution.

T.DIST.RT

LOI.STUDENT.DROITE

Returns the Student's t-distribution.

T.INV

LOI.STUDENT.INVERSE.N

Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.

T.INV.2T

LOI.STUDENT.INVERSE.BILATERALE

Returns the inverse of the Student's t-distribution.

T.TEST

T.TEST

Returns the probability associated with a Student's t-test.

TREND

TENDANCE

Returns values along a linear trend.

TRIMMEAN

MOYENNE.REDUITE

Returns the mean of the interior of a data set.

VAR.P

VAR.P.N

Calculates variance based on the entire population.

VAR.S

VAR.S

Estimates variance based on a sample.

VARA

VARA

Estimates variance based on a sample, including numbers, text, and logical values.

VARPA

VARPA

Calculates variance based on the entire population, including numbers, text, and logical values.

WEIBULL.DIST

LOI.WEIBULL.N

Returns the Weibull distribution.

Z.TEST

Z.TEST

Returns the one-tailed probability-value of a z-test.

Excel: Text Functions

BAHTTEXT

BAHTTEXT

Converts a number to text, using the ß (baht) currency format.

CHAR

CAR

Returns the character specified by the code number.

CLEAN

EPURAGE

Removes all nonprintable characters from text.

CODE

CODE

Returns a numeric code for the first character in a text string.

CONCAT

CONCAT

Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments (2019).

CONCATENATE

CONCATENER

Joins several text items into one text item.

DOLLAR

FRANC

Converts a number to text, using the $ (dollar) currency format.

EXACT

EXACT

Checks to see if two text values are identical.

FIND

TROUVE

Finds one text value within another (case-sensitive).

FIXED

CTXT

Formats a number as text with a fixed number of decimals

LEFT

GAUCHE

Returns the leftmost characters from a text value.

LEN

NBCAR

Returns the number of characters in a text string.

LET

LET

Assigns names to calculation results (365).

LOWER

MINUSCULE

Converts text to lowercase.

MID

STXT

Returns a specific number of characters from a text string starting at the position you specify.

NUMBERVALUE

VALEURNOMBRE

Converts text to number in a locale-independent manner (2013).

PROPER

NOMPROPRE

Capitalizes the first letter in each word of a text value.

REPLACE

REMPLACER

Replaces characters within text.

REPT

REPT

Repeats text a given number of times.

RIGHT

DROITE

Returns the rightmost characters from a text value.

SEARCH

CHERCHE

Finds one text value within another (not case-sensitive).

SUBSTITUTE

SUBSTITUE

Substitutes new text for old text in a text string.

T

T

Converts its arguments to text.

TEXT

TEXTE

Formats a number and converts it to text.

TEXTJOIN

JOINDRE.TEXTE

Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges (2016).

TRIM

SUPPRESPACE

Removes spaces from text.

UNICHAR

UNICAR

Returns the Unicode character that is references by the given numeric value (2013).

UNICODE

UNICODE

Returns the number (code point) that corresponds to the first character of the text (2013).

UPPER

MAJUSCULE

Converts text to uppercase.

VALUE

CNUM

Converts a text argument to a number.

Excel: Database Functions

 

 

 

DAVERAGE

BDMOYENNE

Returns the average of selected database entries.

DCOUNT

BDNB

Counts the cells that contain numbers in a database.

DCOUNTA

BDNBVAL

Counts nonblank cells in a database.

DGET

BDLIRE

Extracts from a database a single record that matches the specified criteria.

DMAX

BDMAX

Returns the maximum value from selected database entries.

DMIN

BDMIN

Returns the minimum value from selected database entries.

DPRODUCT

BDPRODUIT

Multiplies the values in a particular field of records that match the criteria in a database.

DSTDEV

BDECARTYPE

Estimates the standard deviation based on a sample of selected database entries.

DSTDEVP

BDECARTYPEP

Calculates the standard deviation based on the entire population of selected database entries.

DSUM

BDSOMME

Adds the numbers in the field column of records in the database that match the criteria.

DVAR

BDVAR

Estimates variance based on a sample from selected database entries.

DVARP

BDVARP

Calculates variance based on the entire population of selected database entries.



 اذا اعجبك الموضوع لاتبخل علينا بمشاركتة على وسائل التواصل الاجتماع حتى يعم النفع والخير


 

 

Emad ghazi
كاتب المقالة
كاتب ومحرر اخبار اعمل في موقع عالم الاوفيس .

جديد قسم : دوال الاكسل

  1. شكرا لك استاذنا الفاضل وجزاك الله عنا الف خير و جعل ما تقدمه لنا في ميزان حسناتك و حسنات والديك اميييييين يا رب العالمين فقط استاذ هل يمكن تحميل الجدول من فضلك؟ و جزاك الله كل خير

    ردحذف