Excel has many premade formulas, called functions.

December 29, 2025 - As we explore in our guide on Excel ROUND(), the CEILING() function in Excel rounds a number up to the nearest specified multiple. For example: ... Let's look at a worked example below. You'll see that we round F2 to a multiple of 1 and get 4. ... In contrast, the FLOOR() function rounds a number down to the nearest specified multiple. For instance: ... As we can see in the example below, instead of converting 3.24 to 4, it has rounded the number to 3. ... These functions are especially useful when working with standardized intervals, such as rounding prices, time, or quantities to fixed units.

August 12, 2026 - Complete reference for 400+ built-in Excel functions, each with syntax, examples, and usage notes, many with video. Covers VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, COUNTIFS, SUMIFS, SORT, TEXTSPLIT, SEQUENCE, and more.

1 day ago - Working examples for 1000+ common Excel formula tasks, each with a detailed explanation, many with video. Covers key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, COUNTIFS, SUMIFS, SORT, TEXTSPLIT, and more.

In newer versions of Excel, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn't required, you should start using the new functions instead.

1 month ago - A complete list of 500+ Excel functions, grouped by Excel's own categories. Each has a short description, and linked ones open a full tutorial.

May 27, 2026 - Example: =SUBSTITUTE(A2, "Student", "Employee") Substitutes Employee for Student (Employee Details) making it Employee Details. ... The value will fall between 1 and 31. The first day of the month is 1 and the last day is 31. ... With 1 denoting January and 12 denoting December. ... 6. TIME(): The Excel serial number with a time format is created by the TIME() function using the hours, minutes, and seconds provided as numbers.

April 13, 2026 - Full List of Excel Functions and Formulas helps you to understand the functions with Example Formulas. There are 500+ Excel Functions available in the latest version of Excel and counting.

March 20, 2023 - For example, to check the test results in columns B and C and return "Pass" if both are greater than 60, "Fail" otherwise, use the following IF formula with an embedded AND statement: ... If it's sufficient to have just one test score greater than 60 (either test 1 or test 2), embed the OR statement: ... In case you want to take values from two or more cells and combine them into one cell, use the concatenate operator (&) or the CONCATENATE function: ... For example, to combine the values from cells A2 and B2, just enter the following formula in a different cell: ... How to concatenate in Excel - formula examples to combine text strings, cells and columns.

March 21, 2023 - For example, the following SUBSTITUTE formula replaces all commas in cell A1 with semicolons: ... VALUE(text) - converts a text string to a number. This function is really helpful when it comes to converting text-formatted values representing the numbers into numbers that can be used in other Excel formulas and calculations.

A complete list of all Excel functions in alphabetical order.

August 10, 2026 - Discover Excel formulas list with examples: lookup, logical, text, date, and math functions. Learn when to use each and avoid common formula errors.

2 Logical: Learn how to use Excel's logical functions, such as IF, AND, OR and NOT.

December 21, 2022 - Excel Functions List with free downloadable examples. Learn the syntax for 200+ of the most commonly used Excel and Google Sheets functions.

November 20, 2018 - Click function names for details and more examples. Below is a brief overview of about 100 important Excel functions you should know, with links to detailed examples. We also have a large list of example formulas, a more complete list of Excel functions, and video training.

August 30, 2024 - The last function that you will be learning about today is also one of the most powerful in Excel. INDIRECT allows you to specify cell references using text strings. ... For example, instead of typing “=A1”, you can type “=INDIRECT(“A”&1). This means you can dynamically change references. Let’s take the INDEX & MATCH formula you used to retrieve the Last Name. You can get the same result using this formula: ... The INDIRECT function opens up so many possibilities with dynamic references in Excel.

April 10, 2026 - RIGHT formula (extracting variable number of characters within a range): ... This formula extracts the characters from the first space to the end of the text in cell BV1, applied to a range of cells. ... This formula multiplies the values in the ranges BW1 to BW5, BX1 to BX5, and BY1 to BY5, and returns the sum of the products. ... This formula combines the INDEX and MATCH functions to find the first occurrence where the corresponding cells in ranges CA1 to CA10 and CB1 to CB10 meet specific criteria, and returns the value from the range BZ1 to BZ10.

November 6, 2025 - Excel formulas are expressions that we use to perform calculations or manipulate data within a spreadsheet. They are made using predefined functions, mathematical operators, and cell references. Excel formulas are the backbone of data analysis.

May 29, 2026 - 2. AVERAGE: Similar to the SUM function, the AVERAGE function calculates the mean of the values of a range of cells. For example: =AVERAGE (A1:A17). 3. IF: With the IF function, you can ask Excel to return values based on a logical test. The syntax looks like: IF(logical_test, value_if_true, [value_if_false]).

July 14, 2022 - It includes cell references, numbers, ... For example, instead of manually adding a column of values, the SUM function (=SUM(A1:A10)) instantly calculates totals....