Topic: help me about MS EXCEL 2003 & 2007 formulas...

[reinzter]

mga dre may alam ba kayong mga shortcuts na formula sa paggamit ng MS EXCEL 2003 and 2007

example:
@sum()

please help me po...

thx

[neckromancer]

Anong functions ba ang gusto mong mangyari? Grading system ba? Formula ba?

[gshock2kph]

Example: gusto mo mag.total sa lahat ng numbers in Column B, rows 1-10.

Two ways of solving that:

1.  MANUAL WAY. In column B, row 11 type the code below then press enter key.

Code: [Select]

=(B1+B2+B3+B4+B5+B6+B7+B8+B9+B10)

2. USING SUM() FUNCTION

Code: [Select]

SUM(B1+B2+B3+B4+B5+B6+B7+B8+B9+B10)

or

SUM(B1..B10)

hope that helps.

[reinzter]

Example: gusto mo mag.total sa lahat ng numbers in Column B, rows 1-10.

Two ways of solving that:

1.  MANUAL WAY. In column B, row 11 type the code below then press enter key.

Code: [Select]

=(B1+B2+B3+B4+B5+B6+B7+B8+B9+B10)

2. USING SUM() FUNCTION

Code: [Select]

SUM(B1+B2+B3+B4+B5+B6+B7+B8+B9+B10)

or

SUM(B1..B10)

hope that helps.

thx pano naman kung subtraction o multiplication and division ano formula nya?

[gshock2kph]

thx pano naman kung subtraction o multiplication and division ano formula nya?

Basic Operators to be used:

* (multiplication)
/ (division)
+ (addition)
- (substraction)

if you have a formula you can use the = (equal symbol) enclosed within parenthesis.

Example:

Code: [Select]

=(SUM(B1:B10)/(COUNT(B1:B10))*2)