 or or taken why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size     Small Size show me how

# Excel Formulas

TermDefinition
=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
Created by: atpierce87