Data Management: List of Formulas | 公式列表
| English | 中文 | Formula | 公式 |
|---|---|---|---|
| Addition | 加法 | A=SUM(CELL + CELL) | A= SUM( “单元格” + “单元格” ) |
| Subtraction | 减法 | S=SUM(CELL – CELL) | S= SUM( “单元格” + “单元格” ) |
| Addition (List of Numbers) | 加法（数列) | A=SUM(First CELL : Last CELL) | A= SUM( “第一个单元格” + “最后一个单元格” ) |
| Multiplication | 乘法 | M=(CELL * Cell) | M= ( “单元格” * “单元格” ) |
| Division | 除法 | D=(CELL / CELL) | D= ( “单元格” / “单元格” ) |
| Average | 平均数 | A=AVERAGE(First CELL : Last CELL) | A=AVERAGE( “第一个单元格”+“最后一个单元格” ) |
| Count | 计数 | C=COUNT(First CELL : Last CELL) | C=COUNT ( “第一个单元格” + “最后一个单元格” ) |
| Gross Profit | 毛利润 | GP=sum(“Sales Price” – “Cost”) | 毛利润 = ( “销售价格” – “成本” ) |
| Gross Profit Margin | 毛利率 | GPM=(“Gross Profit” / “Sale Price”) | 毛利率 = ( “毛利润” / “销售价格” ) |
| Net Profit | 净利润 | NP= “Gross Profit” – “Operational Expenses” | 净利润 = ( “毛利润” – “运作花费” ) |
| Net Profit Margin | 净利率 | NPM=(“Net Profit” / “Sale Price”) | 净利率 = ( “净利润” / “销售价格” ) |
| Present Value | 现值 | P=F/(1+r)^t | P=F/(1+r)^t |
| Future Value | 未来值 | F=P(1+r) | F=P(1+r) |
| Loans with Compound Interest | 连带复利的贷款 | A=P*(1+r/n)^(n*t) | A=P*(1+r/n)^(n*t) |
| Consumer Price Index | 消费者价格指数 | CPI= {(F-I)/I}*100 | CPI= {(F-I)/I}*100 |
| Inflation | 通货膨胀 | Pn=P*(1+i)^n | Pn=P*(1+i)^n |
| Regular Contribution & Interest | 定期连利存款 | A =P(1 + r)^n + c [ {(1 + r)^n- 1} / r ] | A =P(1 + r)^n + c [ {(1 + r)^n- 1} / r ] |
You might ask why did we use different types of brackets when listing the equation? The reason is simple, it is easier to see the order of operations in complex equations when multiple brakes types are used.