Answer
example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.
=2*3+5
This next formula uses the PMT function to calculate a mortgage payment ($1,073.64), which is based on a 5 percent interest rate (5% divided by 12 months equals the monthly interest rate) over a 30-year period (360 months) for a $200,000 loan:
=PMT(0.05/12,360,200000)
Here are some additional examples of formulas that you can enter in a worksheet.
=A1+A2+A3 Adds the values in cells A1, A2, and A3.
=SQRT(A1) Uses the SQRT function to return the square root of the value in A1.
=TODAY() Returns the current date.
=UPPER("hello") Converts the text "hello" to "HELLO" by using the UPPER worksheet function.
=IF(A1>0) Tests the cell A1 to determine if it contains a value greater than 0.
The parts of a formula
A formula can also contain any or all of the following: functions, references, operators, and constants.
Parts of a formula
1. Functions: The PI() function returns the value of pi: 3.142...
2. References: A2 returns the value in cell A2.
3. Constants: Numbers or text values entered directly into a formula, such as 2.
4. Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.
Using constants in formulas
A constant is a value that is not calculated; it always stays the same. For example, the date 10/9/2008, the number 210, and the text "Quarterly Earnings" are all constants. An expression or a value resulting from an expression is not a constant. If you use constants in a formula instead of references to cells (for example, =30+70+110), the result changes only if you modify the formula.
Using calculation operators in formulas
Operators specify the type of calculation that you want to perform on the elements of a formula. There is a default order in which calculations occur (this follows general mathematical rules), but you can change this order by using parentheses.
Types of operators
There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
Arithmetic operators
To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators.