Examples of using Function returns in English and their translations into Tamil
{-}
-
Ecclesiastic
-
Colloquial
-
Computer
The FV() function returns the future value of an investment,
The LEFT() function returns a substring that contains the'length'leftmost characters of the string. The whole string is returned if'length' exceeds the length of the string. It is an error for the number of characters to be less than 0.
The TYPE() function returns 1 if the value is a number, 2 if it is text, 4 if the value is a logical value, 16 if it is an error value or 64 if the value is an array. If the cell the value represents contains a formula you get its return type.
The ISOWEEKNUM() function returns number of the week which the date falls into.
The COMPOUND() function returns the value of an investment,
The DISC function returns the discount rate for a security. Basis is the type of day counting you want to use:
the number of integer partitions of 16, Mertens function returns 0,[3] and is the number of cubic inches in a U.S. liquid gallon.
The PV() function returns the present value of an investment-- the value today of a sum of money in the future,
The ACCRINT function returns accrued interest for a security which pays periodic interest. Allowed frequencies are 1- annual,
The ACCRINTM function returns accrued interest for a security which pays interests at maturity date.
The SUBTOTAL() function returns a subtotal of a given list of arguments ignoring other subtotal results in there. Function can be
The EOMONTH functions returns the last day in the month specified by a date
The GAMMADIST() function returns the gamma distribution.
The NORMDIST() function returns the normal cumulative distribution.
The RANDNEGBINOM() function returns a negative binomially-distributed pseudo-random number.
The CURRENTDATETIME() function returns the current date and time.
The IN() function returns the natural logarithm of x.
The INT() function returns the integer part of the value.
The ACOT() function returns the inverse cotangent of a number.
The ROOTN() function returns the non-negative nth root of x.