Basic Math Functions

 
Home
Excel Welcome
Spreadsheet Tutorial
Why on a Computer?
Basics of a Spreadsheet
COLUMN Defined
ROW Defined
CELL Defined
150Data Types
Labels in Excel
Constants in Excel
Formulas in Excel
Basic Formulas in Excel
Change in Formulas
Basic Math Functions
Methods of Selecting Cells
Sum Function
Average Function
Max Function
Min Function
Count Function
CountA Function
IF Function
PMT (loan stuff)
SIN COS TAN etc.
Function Wizard
Copying Formulas
Fill Down
Absolute Positioning
Fill Right
Formatting Text
I P Basic Math Functions N

Spreadsheets have many Math functions built into them. Of the most basic operations are the standard multiply, divide, add and subtract. These operations follow the order of operations (just like algebra). Let's look at some examples.

For these following examples let's consider the following data:
  • A1 (column A, row 1) = 5
  • A2 (column A, row 2) = 7
  • A3 (column A, row 3) = 8
  • B1 (column B, row 1) = 3
  • B2 (column B, row 2) = 4
  • B3 (column B, row 3) = 6

 

A

 

B

 

1

 

5

 

3

 

2

 

7

 

4

 

3

 

8

 

6

 

 
Operation

 

 Symbol

 

Constant
Data

 

Referenced
Data

 

Answer
Multiplication

 

 *		= 5 * 6= A1 * B3

 

30
Division

 

 /		= 8 / 4= A3 / B2

 

 2
Addition

 

 +		= 4 + 7= B2 + A2

 

11
Subtraction

 

 -		= 8 - 3= A3 - B1

 

5

1440957

  info@exceltalk.net