wholesaler bifocals swedish jewelry What does Excl's functions mean?

wholesale silver gemstone jewelry india The following is a working table function listed according to the category. For details, see Excel help
database
microsoft Excel contains some work table functions to analyze the data stored in the list or database. These The function is collectively referred to as three parameters of each function: database, field, and criteria. These parameters point to the worksheet area used by the function.

DaveRage returned to select the database bar the average of the database bar

dcount Calculating the number of units containing numbers in the database

dcounta to calculate the non -empty unit in the database

DGET extract a single record that meets the specified conditions from the database

DMAX Returns selected database strips the maximum value

dmin returns the selected database bar goals

DPRODUCT Phase the values ​​of the qualified records in the database

DSTDEV based on the selected database bar estimation standard deviation
ndstdevp based on the selection The overall calculation standard deviation of the database strips

DSUM adds the number in the number of recorded records in the database. n
DVARP's selected database strips The overall calculation variance of the sample calculation

In the data stored in the data perspective table

The serial number of a specific date

dateValue converts the date of the text format to serial number

DAY converts the serial number to the date of the month
nDays360 The number of days during the two days of 360 days

ewate is returned to indicate the serial number of the date before or after the date of the start date

eomonth returns to the specified or after a few months or later The serial number of the moon

hour converts the serial number to hour

minute to the sequence number to minutes

month to the monthly r to the month

In the number of all working days between the two dates

NOW Return to the serial number of the current date and time

Second to convert the serial number to second

time Back to the serial number of a specific time

timeValue converts the time format to serial number

today Return to the serial number of today's date

WEEKDAY converts the serial number to a week of one week

weeknum to convert the serial number to the number of numbers in the week of the week

WorkDay and returned to the specified number of job work. The serial number of the date before or after the date

year converts the serial number to the year of the year

yearfrac returns the number of days between the days between Start_date and END_DATE Scores

In external functions
This functions are used to provide a supplementary program for a custom command or custom function for Microsoft Office. ) The program loads

The converting numbers to euro form, the number is converted from the euro form to the currency form of EU member states, or the euro is used as the intermediate currency to convert the number from the currency of a certain EU member state to another The form of currency of EU member states (triangular conversion relationship).

sql.request is connected to an external data source and runs inquiries from the worksheet, and then returns the query result in the form of an array without macro programming.

The project function
besseli returns the modified Bessel function in (x)

besselj Return to the Bessel function jn (x)
nbesselk and returned to the modified modified The Bessel function KN (X)

bessely returns the Bessel function yn (x)

bin2dec to the binary number

bin2hex to Sixteen -in -production numbers

Bin2OCT convert binary numbers to octagonal number
nComplex to convert the real and virtual coefficients into plurals
nconvert to measure the number from one measuring The system converts to another measuring system

DEC2BIN converts the decimal number to binary numbers

DEC2HEX will convert decimal number to hexadecimal number

DEC2OCT will decimal Number convert to an octagonal number

Delta test whether two values ​​are equal

erf Return error function

erfc Return to the complementary error function
nGestep Check whether the number is greater than the threshold

hex2bin to convert the number of hexada to the binary number

hex2dec to convert the number of hexadecimal numbers to decimal number
nhex2OCT will Sixteen -in -production numbers are converted to octagonal number

imabs The absolute value of the return number (mold number)

imaginary Return the virtual coefficient of the complex number

THETA, that is, the angle represented by the arc

The total plural multiple of the return number

imcos returns the residue of the return number

imdiv to return two plural quotient r r r r r r r

imexp Returns the number of multiple numbers of the number of natural pairs of the number of returns in the return number of returns
nimlog10 of the reciprocated number at the bottom of 10 Back to the pair with 2 as the bottom of the number

impower to return the plural of the overall power

improduct Return to two plural accumulation

imReal return number of returns returned number of returns. The coefficient

imsin returns the number of sine

imsqrt Return to the square root

imsub back to the difference of two plurals

imsum and returned multiple. The plural and

oct2bin converts the octagonal number to binary number

oct2DEC converts octagonal numbers to decimal number

oct2hex to convert octagonal numbers to hexadecimal numbers

Putting interest

accrintm Return to the due interest of the one -due interest in the pride securities

amordegrc returns the depreciation value of each settlement period of the depreciation coefficient

amorlinc Return to the depreciation value of each settlement period

CoupDayBS Return to the number of days of the transaction date within the current interest period

coupdays return to the interest payment period of the transaction day. The number of days

The number of days between the transaction day to the next time the date

Coupncd returns the next rate after the transaction day

coupnum Return to return The number of interests between the transaction date and the maturity date

CoupPCD returns the previous one -time payment day before the transaction day

cumipmt returns the interest paid within two periods n
cumprinc Return a loan that has been repaid in two periods

DB uses a fixed balance method to return to the depreciation value of an asset during the given period r

DDB uses double balance decreased or other specified methods to return a depreciation value of an asset during the given period

DISC to return the discount rate of the securities

DOLLARDE will convert the price represented by score to the price represented by the decimal

dollarfr to convert the price represented by the decimal price to the price expressed by the score The annual period

effect Return to the actual annual interest rate

fv Return to the future value of an investment

Value

intrate Return to the interest rate of one -time interest securities

ipmt Return to an invested interest during the given period

irr returns a series of series The internal yield of cash flow

ispmt Calculating interest during the specific investment period

mduration returns the Macauley correction period of the price of $ 100

MIRR returns the internal yield of the positive and negative cash flow calculated at different interest rates

nominal Return to the nominal interest rate

nper Return to the number of investment periods

npv Back -based based on A series of regular cash flow and stickers The current net value of the current rate of investment

oddfprice returns the price of a price of $ 100 with a non -fixed face value of the first phase of the first phase. The yield rate of price securities

oddlprice Return to the price of a valuable securities price with a non -fixed face value of the end -of -term rate of $ 100

oddlyield returns to the yield of the price of the price of not fixed at the end of the period.

pmt Return to the annuity payment amount

ppmt Return a principal that invests in the return period

price returns the face value of regular interest $ 100 $ 100 The price of the securities

pricedisc returns the price of the price of the price of $ 100 at the discount

priceMat back to the price of the price of the price of the price of $ 100 r r

pv Return to the current value of the investment

rate Returning to the annuity rate of the annuity

Received returned the amount of the fate of the one -time interest securities r

sln Return a linear depreciation value of assets during a certain period

syd to return a depreciation value of the specified period of the assets based on the total annual and depreciation method
ntbilleq The equivalent yield rate of returning to the national treasury coupon

The price of the Treasury coupon with a face value of $ 100

The depreciation value of the penalty assets during or or in some periods

xirr returns a set of internal yields of irregular cash flow

xnpv Return a set of irregular cash flows that occur from time to time The net current value

yield returns the yield of regular interest payable securities

yielddisc The annual yield of the securities (such as the treasury coupon) issued by the discount
n n
yieldmat Return to the annual yield of the securities that matches the securities of securities

In information function
Cell back to the format, location, or content of the cells

error. Type returns the corresponding number of the corresponding error type

info Return to information about the current operating environment

isblank If the value is empty, then return True

iserr If the value is the value is to be the value is the value is Any error value other than#n/a will return True

iserror if the value is any error value, then return True

ISEVEN If the number is the number, then return True
r If the value of Nislogical is a logical value, it returns True

isna If the value is#n/A error value, then return True

isnonText If the value is not text, then return True

isnumber If the value is the number, return True

ISODD If the number is a odd number, then return True

isref If the value is the reference value, then return True

istext If the value is text, return True

n to return to the value of the number of numbers

NA Return error value#n/a
nType返回表示值的数据类型的数字rnrn逻辑运算符rnAND 如果其所有参数为TRUE，则返回TRUErnrnFALSE 返回逻辑值FALSErn
if specifies the logic test to be executed
not logic of its parameters to reverse

or If all parameters are true, return True

true back logic value True

In the search and reference function
address to return the reference value to the single cells of the reference value in the form of text

areas Return the number of areas contained in the reference value
n
CHOOSE Select Value

Column Returns the number of columns referenced

Columns Return the number of columns contained in reference
nhlookup to find the array First line, and return the value of a specific cell

hyperlink to create a shortcut or jump to open the files stored in the network server, Intranet or Internet From the reference or array selection value

indirect Returns the reference specified by the text value

lookup in the vector or array Find value

offset returns the offset from a given reference value

Row Return the number of rows referenced

rows Return the number of rows contained in reference references

RTD supports the method of using the application from other applications or development tools from supporting COM automation (automation: from other applications or development tools. It used to be called "OLE automation", and automation is an industrial standard and component object model (COM) function. ) The procedure returns real -time data

transpose Return to the turn of the array

vlookup to find the first column of the array, move to the line and return the value of the cell

Mathematics and triangular functions
abs Returns the absolute value of numbers

acos Returns the anti -residual string value of the number

acosh back the anti -dual song residue value of the number

ASIN returns the number of string values ​​of numbers

asinh back the anti -dual -song sinus value of the number

atan Return to the number of numbers anyway

atan2 returns X and Y coordinates Anyway, the cut value

atanh returns the anti -dual -curved positive cut value of the number

CEILING into the closest integer or the closest multiple

COMBIN returns the number of combinations of the given number object

COS return to the number of the numbers

Cosh back the number of bisodes of the number

DEGREES to transform the arc to degree ndegrees nDegrees R n
even to give up the number up to the closest number

exp Return to E's given number secondary power

Fact Return to the order multiplier
n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n R N Return to the double -order multiplier

floor to give up the number

gcd return to the largest convention
nInT Go to the closest integer

LCM Return to the smallest public multiple

LN Return to the number of natural pairs of numbers

log according to the specified bottom number, return the number of numbers, Delivery

Log10 Returns the number of numbers at the bottom of the number

mdeterm back to the matrix line of the array

minverse returns the inverse matrix of the array

mmult returns the matrix product of two array

mod Return to the remainder of the removal method

mrop Returns a set of numbers of numbers

odd to give up the number up as the closest odd number

pi to return the value of PI Results

PRODUCT multiplied its parameters

Quotient to return the integer part of the removal method

radians converted angle to arc
nRAND back to return A random number of 0 and 1

The random number of specified numbers

roman converts Arabic numerals into Roman numerals in the form of text

round to position the number as a specified number

rounddown in the direction that decreases into the absolute value

roundup Sake numbers in the direction where the absolute value is increased

SseriesSUM returns the sum of the power level based on the following formulas

sign Return to the symbol of the number

sin Returns the sine value of a given angle

sinh to return the number of the double -song sine

sqrt Return to the square root

sqrtpi back to the product of a certain number of PI and PI The square root

subtotal returns the classification summary of the list or the database

sum adds its parameters

sumifs according to given conditions for several cells. R n
The volume of the corresponding array elements and

sumsq back the square and

sumx2my2 back to the two arrays of the corresponding value of the cupidation difference r r r r r r r r r r r

sumx2py2 Return to the sum of the cubicity of the corresponding value in the two arrays

sumxmy2 Return to the sum of the cubic difference between the appropriate value of the corresponding value in the two arrays

tan Return to the positive cut number of numbers.

tanh Returns the dual -cut value of the number of numbers

trunc to cut the number at the end

The absolute deviation of the values ​​

average returns the average of its parameters

averagea to return its parameter average, including numbers, text and logic value
nbetadist Return to the Beta cumulative distribution function

betainv Return to the anti -function of the cumulative distribution function of the specified Beta distribution

binomdist Return to the probability value of the two -e -terms distribution of one yuan
nChidist return The single tail probability of γ2 distribution

Chinv returns the anti -function of the single -tail probability of γ2 distribution

Chitest Return to independent test value

The confidence interval

Correl returns the correlation coefficient between the two data sets

Count Calculating the number of numbers in the parameter list

counta Calculating parameter list value list Number

In the number of blank units in the calculation interval

countif calculation to meet the number of non -empty units in the interval where the given conditions is met

c OVAR returns to the co -party difference, the average of the pair of deviation multiplication

Critbinom returns to the minimum value of the cumulative dual -e -terms distribution of less than or equal to the critical value
nDevSQ return deviation

expondist Return the index distribution

fdist Return F probability distribution

finv Return to the anti -function value of F probability distribution
nfisher back Fisher transformation r r r r r r r r

fisherinv returns the anti -function value of the Fisher transformation

Forecast Return to the value of the along line

frequency return to the frequency distribution of vertical array

FTEST returns the results of the F test

gammadist Return to gamma distribution

gammainv Return to the anti -function of gamma cumulative distribution function

gammmmaln returns to the gamma function. Number, γ (x)

geomean return geometric average

growth Return to the value of the index trend

harmean Return and the average n Returning to super geometric distribution

INTERCEPT Return to the cutting line of linear return

kurt Return to the peak of the data set

large back data set Kesta maximum value

linest Returns the parameters of the linear trend

logest Return to the parameters of the index trend

loginv Return to the counter -function of the number distribution function

Return to return Cumulative distribution function

max Returns the maximum value in the list of parameters

maxa to the maximum value in the parameter list, including numbers, text and logic value

MEDIAN 返回给定数值集合的中值rnrnMIN 返回参数列表中的最小值rnrnMINA 返回参数列表中的最小值，包括数字、文本和逻辑值r n
mode returns the value of the most frequently appeared in the data set

The negative two -e -terms distribution

normdist Return to normal cumulative distribution
nnorminv return to return The anti -function of normal cumulative distribution

normsdist returns standard normal cumulative distribution

normsinv back to the anti -function of normal cumulative distribution
npearson back PEARSON multiplication multiplication revolution Related coefficients

It returned to K -k in the area The value of a percentage point

The percentage ranking of the value of the data concentration

Permut Return the number of arranges of the given number object

poisson returns to Poison distribution

Prob returns the value in the region to fall in the specified range

QUARTILE Return to the quarterly digits of the data set

RANK to return a number of digital digital rankings

RSQ Return to the square
n nskew back distributed biasedness

slope back linear backline

SMALL returns the data concentration. The minimum value

The return to the normalized value

stdev estimates based on the standard deviation of the given sample

stdeva estimated Standard deviations of samples (including numbers, texts and logic values)

stdevp Calculation Based on a given overall standard deviation

stdevpa Calculation ) Standard deviation

steyx Returns the standard error generated by calculating the Y predictive value of each X through the linear regression method

tdist returns students' T distribution

tinv returns the anti -function of the T distribution of students

trend return to the value of the alongs of the along line

trimmean back to the internal average of the data set
nttest back and students The probability of the T test

VAR estimates the variance based on samples

Vara estimates the variance based on samples (including numbers, text and logic)

varp calculation Found difference based on the overall sample

varpa Calculate the variance based on the overall sample (including numbers, text, and logic)

weibull Return to Weber distribution
nztest back to Z inspection Single -tail probability value

text and data functions
asc to change the full -angle (dual byte) or chip names in the string to semi -lessee (single byte) character n
bahttext uses ß (Thai baht) currency format to convert numbers into text
n nCHAR back to the characters corresponding to the code number

Clean to delete the non -printed characters in the text

code Return to the digital code of the first character in the text string

merged several text items into a text item

dollar use $ (USD) currency format will Digital conversion text This

exact checks whether the two text values ​​are the same

Find to find another text value in one text value (distinguished in smallcuentials)

fixed to form the number format Set to have a fixed decimal digits

jis to change the English letters or pseudonym in the half -angle (single byte) or chip names in the string to the full -angle (dual byte) character
nleft Return to the text The leftmost character in the value

len Return the number of characters in the text string

lower to convert the text into a lowercase
nmid in the text string, Start from your specified position to return the specified number of characters

phonetic extract the pinyin character in the text string

proper to the first letter of each word of the text value

Replace replace the characters in the text

REPT repeats the text of the text

Right R nSearch finds another text value in one text value (not distinguished by the case)

In new text in the text string to replace the old text

t to convert its parameters to conversion为文本rnrnTEXT 设置数字格式并将其转换为文本rnrnTRIM 从文本删除空格rnrnUPPER 将文本转换成大写形式rn
Value converts text parameters to numbers