Home MS Excel TutorialExcelFunctions Functions Examples
Category:

# Functions Examples

• ## Avoid Errors Using IFERROR-Everyone Should Know

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 …

• ## How to Make an Excel IF Statement

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.

• ## Holidays in Excel

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.

• ## Kg to lbs in Excel – Easy Converter

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.

• ## Shortest Path Problem in Excel

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).

• ## EVEN and ODD in Excel – Easy Formulas

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

• ## Frequency Distribution in Excel

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.

• ## How to use the SUBTOTAL function – Easy Excel Formulas

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.

• ## How to use FREQUENCY in Excel

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.

• ## Create External References in Excel

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).