used in higher-level operations, such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.
number of cells in a range that contain numbers.
number of cells in a range that contain value or letter.
cells that meet a condition set forth in the formula.
used to calculate a period of time.
calculates difference in days between two dates.
used to assist in organizing spreadsheet information.
used for two column vectors.
used to compare a cell value to an array of cells and return a value that matches the location of the value in the array.
allows additional entries other than those provided in the drop-down menu.
returns the current date.
limits data entry to specific choices programmed into the function.
used when there are more than two columns in the array (lookup table).