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).
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions above and try again
Reload the page to try again!
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ.