Formula

The term "formula" has several different meanings, depending on the field in which the term is used. For example, a mathematical formula is a relationship expressed using numbers and symbols. A chemical formula defines the atomic structure of a chemical compound. In computing, a formula is a calculation performed on one or more variables.

Formulas and Functions

Functions in computer programs often contain formulas. A simple formula, for instance, might convert centimeters to inches. This formula, along with several others, may be used within a metric conversion function. The function can apply the appropriate formula to the input (typically defined by the input parameters) and produce the resulting value as output. Formulas and functions are similar and sometimes the terms are used interchangeably. However, formulas are often the building blocks of functions, not the other way around.

Spreadsheet Formulas

Formulas are also used in spreadsheets. Most spreadsheet applications allow you 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. Entering the formula "=A2+B2" in cell C2 would display the sum of the cells A2 and B2 in C2. 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.

NOTE: To enter a formula in a spreadsheet, start by typing an equal sign (=) into an empty cell.

Updated June 7, 2019

Definitions by TechTerms.com

The definition of Formula on this page is an original TechTerms.com definition. If you would like to reference this page or cite this definition, you can use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about the Formula definition or would like to suggest a new technical term, please contact us.

Want to learn more tech terms? Subscribe to the daily or weekly newsletter and get featured terms and quizzes delivered to your inbox.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.