Create a simple formula in Excel - Microsoft Support
How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.
Create custom functions in Excel - Microsoft Support
Although Excel includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. Custom functions, like macros, use the …
Create a simple formula - Microsoft Support
The workbook below shows examples simple formulas. You can change any of the existing formulas, or enter your own formulas to learn how they work and see their results.
Overview of formulas in Excel - Microsoft Support
Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.
Create a formula by using a function - Microsoft Support
You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM (A1:A2) and SUM (A1,A2) both use the SUM function to add the values in …
Calculate percentages - Microsoft Support
Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!
Use calculated columns in an Excel table - Microsoft Support
Formulas you enter in Excel table columns automatically fill down to create calculated columns.
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
Create an array formula - Microsoft Support
Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results.
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. …