تحميل برنامج يومية الايرادات والمصروفات مجانى 100 %

 

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

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

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

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

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

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

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

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

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

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

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

دوال هندسية

دوال المالية

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

دوال منطقية

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

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

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

دوال النصية

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.

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