Math excel week 1&2

Rows

- Extend from left ro right

- To hold data such as names, dates, and descriptions

- Row identified by a number

Columns

- Strech from top of the sheet to bottom

- To categorise data like expense, quantities, and totals

- Column indenfied by letters

SUM:

"=SUM"

Arguments

The value, references, or text that you provide to a function

Example: In a SUM function the arguments are the numbers you want to add together

Separators

- For excel to understand formulas you need to use separators

- Tells Excel where one argument ends and next one begins

Growth rate base formula

(Final - Initial value) / Initial value

postive growth rate without tax

Final = Initial * (1+Gr)

postive growth rate with tax

Initital = Final / (1+Gr)

negative growth rate

Final / (1-Gr)

Sequential growth rate

Final = Inital * (1+Gr1) * (1-Gr2) * (1-Gr3) * (1+Gr4)

Overall growth rate

(1+Gr1) * (1+Gr2) - 1

Profit

Selling price - cost price

Markup

(Selling price - cost) / cost price

Return

(Selling price - cost price) / selling price

Total quanity

SUM

Average quanity

AVG

Highest quanity

MAX

Smallest quanity

MIN

how many left in a period

COUNTA

how many in a period

COUNT

how mant in a period variable

COUNTIF