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
MOD takes a number and divisor, and returns the remainder...
- 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
To round prices to end in the nearest, .99 value, you can...
- BMI Calculation Formula
Lists all Excel functions by their category, such as Logical functions or Text functions.
Learn how to create formulas and use built-in functions to perform calculations and solve problems in Excel. Download a tutorial workbook, browse through formula elements, and get help from experts.
20 mar 2023 · Learn the essentials of Excel formulas and functions with 10 examples of common calculations. Find out how to use SUM, AVERAGE, MAX, MIN, COUNT, COUNTA and more in your spreadsheets.
Learn how to use formulas and functions in Excel to perform calculations, analyze data, and create custom formulas. Find examples, references, errors, and tips for various functions and scenarios.
Find over 350 built-in functions for Excel, with examples and videos. Learn how to use functions for logical, date and time, lookup and reference, text, dynamic array, engineering, financial, information, math, trigonometry, statistical, web, database and more.
Learn the basic concepts and skills of formulas and functions in Excel, such as cell references, relative and absolute references, and how to enter and edit formulas. See examples, videos, and tips for using functions and arguments.