excel formulas pdf with example 2013 download free

Example: TRIM(A1)Ĭhecks whether a condition is met and returns one value if true and another if false Example: IF(A1=‘Yes’, True, False)Ĭombines the values of multiple cells into a single cell. Removes all white space from the front and back of a cell.

Example: SUMIFS(A1:A4,B1:B4,E1)Ĭalculates the average values in a range of cells Example: AVERAGE(A1:A4)Ĭounts the number of cells in a range that contains numbers Example: COUNT(A1:A4)įinds the smallest value in a range of cells Example: MIN(A1:A4)įinds the largest value in a range of cells Example: MAX(A1:A4)

SUMĪdds the values of a range of cells Example: SUM(A1:A4) Here are some of the most common Excel formulas in our Excel functions list cheat sheet. They help parse information and display it for a variety of uses. In Excel, a function is simply a preset formula or algorithm. Example: TRUE, FALSEĪrray formulas perform calculations on a range of cells simultaneously. Example: 1.12ĭates and times track and calculate data over time. Numbers are used for calculations and can be formatted as currency, percentages, decimals, etc. TextĪlso called labels, text values identify data in a worksheet or store things like names and descriptions. Here are the data types that Excel frequently stores.

Rows are identified by numbers (1, 2, 3, etc.)Īlso known as a spreadsheet the grid of columns and rows that you can enter in ExcelĪs a spreadsheet program, Excel focuses on storing data. Columns are identified by letters (A, B, C, etc.)Ī set of instructions that performs calculations on values in the worksheetĪ predefined formula is used to perform standard calculations, such as summing a range of valuesĪ horizontal group of cells in the worksheet. The currently active cell in the worksheetĪn individual box in the worksheet that can contain data, text, or a formulaĪ vertical group of cells in the worksheet.

Excel formulas pdf with example 2013 download free