VII. Understanding formulas and functions

1. Understand the Excel Formula

In Excel, the input formula must start with "=", but "=" is meaningless.

1. Operators

Arithmetic Operator: +-*/% & ^ (&: concatenation character, ^: Multiplication party)

Comparison OPERATOR: <>=<=<> (<>: not equal)

Result of comparison operator: true (1) False (0)

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M00/4D/9A/wKiom1RUkirAfvUCAABaNeO2Gvo754.jpg "Title =" qq20141101155552.jpg "alt =" wkiom1rukirafvucaabaneo2gvo754.jpg "/>

2. Cell reference

When the formula in a cell is referenced to another cell, the formula content changes accordingly, and this is relative reference. Instead, it locks a part of the formula, so that it is referenced to other cells and does not change accordingly. This is absolute reference. Hybrid reference is used to lock a row or column.

Relative reference: A1

Absolute reference: $ A $1. Press [F4] to enable it. the rows and columns behind $ are fixed and will not change.

Hybrid reference: $ A1, a $1 switch by [F4] ($ A1: Column A is locked, and the row can be changed; Row A $ is locked, and the column can be changed)

Ii. recognition functions

1. How to Write Functions

Starting with equal sign

The function name is in the middle

End of brackets

Brackets

Sum: = sum (D5: G5)

Average: = average (D5: H5)

Maximum: = max (D5: D11)

Minimum value: = min (D5: D11)

Rank: = rank (H5, $ h $5: $ h $11)

Count: = count (D5: G5), counta

2. You can use the positioning tool to select the position of the input formula, and use the [automatic summation] tool to complete the Skip summation.

Start -- Auto sum -- sum; average value ;...

VII. Understanding formulas and functions