Need Help ?

Microsoft Excel – Formula

Course - Fun With Excel

Published on 5 Dec 2020 at 04:67

What is Formula?

What you think when I say formula. In terms of math, word “formula” reminds you the math’s formula you used in your math’s class like (a + b)2 = a2 + b2 + c2 or in simple terms a + b = c.

Here, if you notice formula defines the relation between these values. In formula a + b = c, value of relation of a & b originate the value of c. So we can say that - formula describe the relation among entries or data and helps to get a results. Here instruction of addition (a + b) is a relation of mathematical operation.

Similarly, in excel we use formula to describe a relationship between cells with the help of mathematical operation like addition, subtraction, multiplication and division and much more. Since there is many cells in worksheet so we used cell address to defined a relationship. Like A1, AA2, CCC12 etc. (example of cell address)

So, formula is defined as – An entry of cell address and mathematical operator in a sequence so we can get a new value which is generated from operating given value.
Formula for adding a value of cells B15 and C15 is –

=B15 + C15 (here, two cell address are written down with addition sign (mathematical operation).)
“=” is placed before cell address. “=” equal sign indicated the cells that we are going to write a formula and its need to calculated the data of given cells address. Unless data will treated as entry and not get executed.

Formula which you entered in cells is also can see in formula bar. On entering a formula its generates the result, so if a new person want to know that which formula is enter in this cell so, on selecting the cell the formula can be seen in formula bar.