Search results
Find over 500 working Excel formulas with detailed explanations, videos, and related links. Learn how to use key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.
- BMI Calculation Formula
This example shows one way to calculate BMI (Body Mass...
- Count Specific Words in a Cell
If you need to count how many times a specific a word (or...
- Round a Number up to Nearest Multiple
This tells Excel to take the value in B6 ($33.39 ) and round...
- Fixed Value Every N Columns
The Excel COLUMN function returns the column number for a...
- Currency Exchange Rate Example
To get historical currency exchange rates over time, you can...
- Round Price to End in .45 Or .95
To round prices to end in .45 or .95, depending on whether...
- Get Column Name From Index in Table
To get the name of a column in an Excel Table from its...
- Round a Price to End in .99
MROUND rounds to nearest values based on a supplied...
- BMI Calculation Formula
22 wrz 2024 · Learn how to use 15 essential Excel formulas for arithmetic, string, time series, and complex data analysis. See examples, exercises, and tips for adding formulas manually or using GUI.
21 mar 2023 · Learn the basics and advanced techniques of creating and using Excel formulas with this tutorial. Find out how to use operators, functions, cell references, and more with practical examples.
6 lip 2024 · This tutorial provides multiple examples and methods related to the use of Excel formula list. You can download the workbook and practice.
20 mar 2023 · Learn how to use 10 essential Excel functions to perform calculations, sum, average, count, and more. See examples, tips, and links to in-depth tutorials for each function.
Learn how to create formulas from the data in your worksheet with sample data and guidance. Find links to articles and videos for different types of formulas, such as conditional, lookup, date and time, financial, statistical, math, counting, conversion, text, and more.
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.