Free download excel formulas and functions

While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. About Us Contact Us Testimonials Donate Follow us. Please re-enable javascript in your browser settings. DIST WS Returns the beta distribution BETA.

Returns the depreciation of an asset based on the fixed-declining balance method. Returns the depreciation of an asset based on the double-declining balance method. Returns the depreciation of an asset based on the straight-line depreciation method. Returns the depreciation of an asset based on the sum-of-years' digits depreciation method. Returns the depreciation of an asset based on a variable declining balance depreciation method.

INV WS Returns the inverse of the cumulative beta probability density function BETADIST WS Returns the cumulative beta probability density function BETAINV WS Returns the inverse of the cumulative beta probability density function BINOM.

VBA functions are built-in functions that are used in Excel's programming environment called Visual Basic for Applications VBA. Below is a list of Excel formulas sorted by category.

Returns the y-axis intersection point of a line using x-axis values and y-axis values. Uses the least squares method to calculate the statistics for a straight line and returns an array describing that line. Returns the largest value from the values provided numbers, text and logical values.

Returns the average of all numbers in a range of cells, based on a given criteria. Returns the average of free download excel formulas and functions numbers in a range of cells, based on multiple criteria. Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion. Returns the inverse of the one-tailed probability of the chi-squared distribution.

Used to retrieve information about a cell such as contents, formatting, size, etc. Returns the accrued interest for a security that pays interest on a periodic basis. Returns the linear depreciation of an asset for each accounting period, on a prorated basis. Returns the depreciation of an asset for each accounting period, on a prorated basis.

Returns the variance of a population based on a sample of numbers, text, and logical values. Returns the variance of a population based on an entire population of numbers, text, and logical values. Returns one value if the condition is TRUE or another value if the condition is FALSE. IF more than 7 WS. Returns a value if a specified condition evaluates to TRUE or another value if it evaluates to FALSE. Evaluates a list of expressions and returns the corresponding value for the first expression in the list that is TRUE.

If you would like an alphabetical list of these formulas, click on the following button:. Enter a value in the field above to quickly find functions in the list below. Home About Us Contact Us Testimonials Donate.

Returns the covariance, the average of the products of deviations for free download excel formulas and functions data sets. Returns how often values occur within a set of data. It returns a vertical array of numbers.

Returns the smallest value from the values provided numbers, text and logical values. Returns the standard deviation of a population based on a sample of numbers, text, and logical values. Returns the standard deviation of a population based on an entire population of numbers. Returns the standard deviation of a population based on an entire population of numbers, text, free download excel formulas and functions logical values.

We use advertisements to support this website and fund the development of new content. Returns a text representation of a number rounded to a specified number of decimal places. Returns the position of the first occurrence of a string in another string, starting from the end of the string.

Returns the smallest number in a column in a list or database, based on a given criteria. Returns the product of the numbers free download excel formulas and functions a column in a list or database, based on a given criteria. Returns the standard deviation of a population based on the entire population of numbers.

Returns the internal rate of return for a series of cash flows that may not be periodic. Averages all numbers in a column in a list or database, based on a given criteria. Returns the number of cells in a column or database that contains numeric values and meets a given criteria. Returns the number of cells in a column or database that contains nonblank values and meets a given free download excel formulas and functions. Returns the largest number in a column in a list or database, based on a given criteria.

Returns an integer that represents the attributes of a file, folder, or directory.

Apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows. Returns a number rounded up to the nearest integer or to the nearest multiple of free download excel formulas and functions. Returns the number of combinations for a specified number of items and includes repetitions. Used to change the seed value used by the random number generator for the RND function. Multiplies the corresponding items in the arrays and returns the sum of the results. Returns the sum of the squares of the differences between corresponding items in the arrays.

Convert currency into words Convert number into words Insert a double quote in a formula Test a string for an alphanumeric value How to Autonumber in Excel Delimit values with ASCII 29 character Creating a custom round function Creating a custom average function that excludes outlyers from the calculation. Home About Us Contact Us Testimonials Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy.

Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel.

DIST WS Returns the individual term binomial distribution probability BINOM. WEND VBA Used to create a WHILE LOOP Information Functions CELL Free download excel formulas and functions Used to retrieve information about a free download excel formulas and functions such as contents, formatting, size, etc. ENVIRON VBA Returns the value of an operating system environment variable ERROR. Functions CBOOL VBA Converts a value to a boolean CBYTE VBA Converts a value to a byte ie: Two-Dimensional Lookup Example 1 Two-Dimensional Lookup Example 2 Two-Dimensional Lookup Example 3 Two-Dimensional Lookup Example 4.

Adds free download excel formulas and functions specified number of months to a date and returns the result as a serial date. Calculates the last day of the month after adding a specified number of months to a date. Returns the number of work days between 2 dates, excluding weekends and holidays. Adds a specified number of work days to a date and returns the result as a serial date. Adds a specified number of work days to a date and returns the result as a serial date customizable weekends.

Counts the number of cells that contain numbers as well as the number of arguments that contain numbers. Counts the number of cells that are not free download excel formulas and functions as well as the number of value arguments provided.