click below
click below
Normal Size Small Size show me how
Excel Formulas
Term | Definition |
---|---|
=DB | Returns the straight line depreciation amount of an asset for a given period |
=FV | Returns the future value of an investment based on periodic, constant payments and a constant interest rate |
=PMT | Calculates the payment for a loan based on constant payments and a constant interest rate |
=PV | Returns the present value of an investment. The total amount that a series of future payments is worth now |
=TIME | Returns the number that represents a particular time |
=TODAY | Today’s date |
=RAND | Returns a random number greater than or equal to 0 and less than 1, evenly distributed |
=RANDBETWEEN | Returns a random number between the numbers you specify |
=ROUND | Rounds a number to a specified number of digits (Not only how to do it, but what is does. This impacts when you have to foot and cross foot something in excel. Easy to be off a dollar.) |
=ROUNDDOWN | Rounds a number down, toward zero |
=ROUNDUP | Rounds a number up, away from zero |
=SUM | Adds all the numbers in a range of cells (We use this a LOT to roll up trial balances and sub ledgers) |
=SUMIF | Adds the cells specified by a given criteria (We use this a LOT to roll up trial balances and sub ledgers) |
=SUMIFS | Adds the cells specified by a given set of criteria or conditions (We use this a LOT to roll up trial balances and sub ledgers) |
=AVERAGE | Returns the average of its arguments, which can be numbers or names, arrays, or references that contain numbers. |
=AVERAGEIF | Finds average for the cells specified by a given condition or criteria |
=AVERAGEIFS | Finds average for the cells specified by a given set of conditions or criteria |
=CORREL | Returns the correlation coefficient between two data sets |
=COUNT | Counts the number of cells in a range that contain numbers |
=COUNTIF | Counts the number of cells within a range that meet the given condition |
=COUNTIFS | Counts the number of cells specified by a given set of conditiosn or criteria |
=LARGE | Returns the k-th largest value in a data set |
=MAX | Returns the maximum value in a list of arguments |
=MEDIAN | Returns the median, or the number in the middle of the set of given numbers |
=MIN | Returns the smallest value in a list of arguments |
=RANK | Ranks the rank of a value within a list of values |
=SMALL | Returns the k-th smallest value in a data set |
=COLUMN | Returns the column number of a reference |
=GETPIVOTDATA | Returns data stored within a PivotTable |
=HLOOKUP | Looks for a value in the top row of a table or array of values and returns the value in the same column for a row you specify |
=INDIRECT | Returns the reference specified by a text value |
=ROW | Returns the row number of a reference |
=TRANSPOSE | Converts a vertical range of cells to a horizontal range, or vise versa |
=VLOOKUP | Looks for the value in the leftmost column of a table, and then returns a value in the same row from a column you specify. |
=CONCATENATE | Joins several text strings into one text string |
=LEFT | Returns the specified number of charters from the start of a text string |
=LEN | Returns the number of characters in a text string |
=MID | Returns a specific number of characters from a text string starting at the position you specify |
=TRIM | Removes all spaces from text string, except for single spaces between words |
=AND | Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE |
=IF | Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE |
=IFERROR | Returns value_if_error if expression is an error and the value of the expression itself otherwise |
=IFNA | Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula. |
=OR | Checks whether any of the arguments are TRUE, and then returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE |
=ISBLANK | Checks whether a reference is to an empty cell, and returns TRUE or FALSE |
=ISERROR | Checks whether a value is an error, and returns TRUE or FALSE |
=ISEVEN | Returns TRUE if the number is even |
=ISODD | Returns TRUE if the number is odd |