Functions Examples

Use the IFERROR function in Excel to return an alternative result, such as text, when a formula evaluates to an error. For example, Excel returns the #DIV/0! error …

The IF function in Excel checks whether a condition is met, and returns one value if true and another value if false. This page contains many easy to follow IF examples.

This example teaches you how to get the date of a holiday for any year (2021, 2022, etc). If you are in a hurry, simply download the Excel file.

1 kg = 2.20462 lbs (pounds) and 1 lb (pound) = 0.45359 kg. Use a simple formula, the CONVERT function or download our free unit converter to convert from kg to lbs or vice versa.

Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S, A, B, C, D, E and T). Lines in a network are called arcs (SA, SB, SC, AC, etc).

Use EVEN and ODD in Excel to round numbers. Use ISEVEN or ISODD in Excel to determine if a number is even or odd.

Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram.

Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or to ignore manually hidden rows.

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table. You can also use the COUNTIFS function to create a frequency distribution.

An external reference in Excel is a reference to a cell or range of cells in another workbook. Below you can find the workbooks of three divisions (North, Mid and South).