Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

The MOD function in Microsoft Excel lets you work out whether one number is divisible by another. If it's not, it tells you what's left over. For example, if you divide 3 by 2, the MOD function ...

If you’d like to learn about XLOOKUP(), read How to use the newish XLOOKUP() dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

The syntax for the GCD function is below: Number 1, number 2: Number 1 is required; numbers after are optional. If any number is not an integer, it is truncated.

How to do a basic search in Excel We want to enter characters one at a time and see the first matching value and a corresponding value. Excel’s autocomplete feature works with data input.