Home : Technical Terms : Formula Definition

Formula

The term "fomula" has several different meanings, depending on the field in which the term is used. In mathematics, a formula is a mathematical relationship expressed using numbers and symbols. In chemistry, a formula may be used to define the atoms that make up a chemical compound. In computing, a formula is simply a calculation that is performed on one or more variables.

Functions within computer programs often contain formulas. These formulas are used to process data that is passed through the function and output the result. For example, a basic formula might convert inches to centimeters. This type of formula may used in a metric units conversion function. Formulas and functions are similar, and the terms are even sometimes used interchangeably. However, it is important to know that formulas are often the building blocks of functions, and not the other way around.

Formulas are also commonly used in spreadsheets. Most spreadsheet applications allow users to enter formulas into cells instead of static data. For example, if a spreadsheet contains numbers in columns A and B, column C could be used to total the numbers in the respective rows of columns A and B. This would be accomplished by entering the formula "=A2+B2" in C2, and "=A3+B3" in C3, and similar functions in the rest of the cells in column C. More advanced spreadsheet formulas can be used to determine the average of multiple cells, divide cells by the results of other formulas, and perform other complex operations.

Updated: February 12, 2010

Cite this definition:

https://techterms.com/definition/formula

TechTerms - The Tech Terms Computer Dictionary

This page contains a technical definiton of Formula. It explains in computing terminology what Formula means and is one of many technical terms in the TechTerms dictionary.

All definitions on the TechTerms website are written to be technically accurate but also easy to understand. If you find this Formula definition to be helpful, you can reference it using the citation links above. If you think a term should be updated or added to the TechTerms dictionary, please email TechTerms!