Help with Excel Functions and Formulas

Alphabetically Ordered Functions

If you know the name of the
function you want, select from the
Alphabetical Excel Functions List.

Popular Searches

Text Functions:

Excel Find Function
Excel Search Function

Logical Functions:

Excel If Function
Excel And Function
Excel Or Function

Lookup & Reference Functions:

Excel Match Function
Excel Vlookup Function
Vlookup Example

Math & Statistical Functions:

Excel Sumif Function
Excel Sum Function
Excel Countif Function
Excel Rounding Functions

VBA Functions:

VBA Vlookup
VBA InStr Function
VBA MsgBox Function

Other:

Percentages in Excel
Split String in Excel
Time Difference in Excel
Convert Time to Decimal

What's New on ExcelFunctions.net?

Excel Freeze Panes
Excel Named Ranges
Random Number Generator
Find Duplicate Rows
Remove Duplicate Rows
Convert Text to Number
Convert Text to Date

This website provides help with Excel functions and formulas.

You will find information and examples of each of the Excel Built-In Functions and examples of how to perform popular tasks using Excel Formulas. There is also a section explaining Excel Array Formulas, which will help you to make full use of some of the most useful Excel functions and formulas.

For beginners, our Basic Excel pages will give you a strong understanding of the basic Excel concepts, which will help you to get the best use of Excel functions and formulas. There is also a section on Excel Errors which will help you to diagnose and fix any errors that you encounter.

Finally, for those who want to learn how to program their own functions in Excel, we have an Introductory Guide to Excel Macros and an Excel VBA Tutorial. With the help of our step-by-step guides, Excel macros will become a natural part of your spreadsheet development, enabling you to perform complex analysis and automate repetitive tasks.

The examples on this site mostly apply to all versions of Excel, from 2003 onwards. However, some of the built-in functions are only available in the most recent versions of Excel. If you are currently using an older version of Microsoft Office, and would like to try the latest version, you can get a free trial on the Microsoft Office website.