Exceljet

Quick, clean, and to the point

Excel 2003

The functions below are available Excel 2003 and later versions, including Excel 365.

Excel PRICEDISC function
The Excel PRICEDISC function returns the price per $100 face value of a discounted security.
Excel PRICEMAT function
The Excel PRICEMAT function returns the price per $100 face value of a security that pays interest at maturity.
Excel PRODUCT function

The Excel PRODUCT function returns the product of numbers provided as arguments. The PRODUCT function is helpful when multiplying many cells together. The formula =PRODUCT(A1:A3) is the same as =A1*A2*A3.

Excel PROPER function

The Excel PROPER function capitalizes each word in a given text string. Numbers, punctuation, and spaces are not affected.

Excel PV function
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today's dollars of a series of future payments, assuming periodic, constant payments and a constant...
Excel QUARTILE function

The Excel QUARTILE function returns the quartile (each of four equal groups) for a given set of data. QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.

Excel QUOTIENT function

The Excel QUOTIENT function returns the integer portion of division without the remainder. Use QUOTIENT to discard the remainder after division.

Excel RADIANS function

The Excel RADIANS function converts degrees to radians. For example, =RADIANS(180) returns 3.1415 or the value of π (pi).

Excel RAND function

The Excel RAND function returns a random number between 0 and 1. For example, =RAND() will generate a number like 0.422245717. RAND recalculates when a worksheet is opened or changed.

Excel RANDBETWEEN function
The Excel RANDBETWEEN function returns a random integer between two given numbers. RANDBETWEEN recalculates each time a worksheet is opened or changed.
Excel RANK function

The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time).

Excel RATE function

The Excel RATE function is a financial function that returns the interest rate per period of an annuity. You can use RATE to calculate the periodic interest rate, then multiply as required to derive the annual interest rate. The RATE function...

Excel RECEIVED function
The Excel RECEIVED function returns the amount received at maturity for a fully invested security.
Excel REPLACE function

The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example =REPLACE("XYZ123",4,3,"456") returns "XYZ456".

Excel REPT function

The Excel REPT function repeats characters a given number of times. For example, =REPT("x",5) returns "xxxxx".

Excel RIGHT function

The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. For example, RIGHT("apple",3) returns "ple".

Excel ROMAN function
The Excel ROMAN function converts a number to a Roman numeral as text. For example, the formula =ROMAN(4) returns IV.
Excel ROUND function

The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.

Excel ROUNDDOWN function

The Excel ROUNDDOWN function returns a number rounded down to a given number of places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN rounds all numbers down.

Excel ROUNDUP function

The Excel ROUNDUP function returns a number rounded up to a given number of decimal places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP rounds all numbers up.

Excel ROW function

The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

Excel ROWS function

The Excel ROWS function returns the count of rows in a given reference. For example, ROWS(A1:A3) returns 3, since the range A1:A3 contains 3 rows.

Excel SEARCH function

The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of the first character of find_text inside within_text. Unlike FIND, SEARCH allows wildcards, and is not case-sensitive.

Excel SECOND function

The Excel SECOND function returns the second component of a time as a number between 0-59. For example, with a time of 9:10:15 AM, second will return 15. You can use the SECOND function to extract the second into a cell, or feed the result into...

Excel SIGN function

The Excel SIGN function returns the sign of a number as +1, -1 or 0. If number is positive, SIGN returns 1. If number is negative, sign returns -1. If number is zero, SIGN returns 0.

Excel SIN function

The Excel SIN function returns the sine of an angle given in radians. To supply an angle to SIN in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians.

Excel SINH function
The Excel SINH function returns the hyperbolic sine of a number.
Excel SKEW function

The Excel SKEW function returns the skewness of a distribution, which is a measure of symmetry. A positive result indicates a distribution that tails off to the right. A negative result indicates a distribution that tails off to the left...

Excel SLN function

The Excel SLN function returns the depreciation of an asset for one period, calculated with a straight-line method. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is...

Excel SLOPE function

The Excel SLOPE function returns the slope of a regression line based on known y values and known x values. A regression line is a "best fit" line based on known data points.

Pages