An Excel formula is a way of defining a specific calculation in a worksheet. In Excel, all formulas must begin with an equals sign (=). For example, to add 100 to a value in A1, you can write a formula like this:
This formula will always add 100 to the value in A1, even when that value changes.
Formulas with Functions
Excel contains hundreds of pre-built formulas called functions. You can use functions on their own in formulas, or even combine multiple functions in a single formula.
For example, the this formula uses only the MAX function to calculate the maximum value in the first 100 cells in column A:
An Excel function is a pre-built formula with a specific purpose. Excel provides hundreds of functions in various categories like dates and times, text, statistics, lookup, financial, engineering, etc. Most Excel functions require specific inputs,...