Excel Functions
Select a term from the languages table to see its function, syntax and description.
| English | German | French | Spanish | Italian | Portuguese |
|---|---|---|---|---|---|
| sum | summe | somme | suma | somma | soma |
| if | wenn | si | si | se | se |
| and | und | et | y | e | e |
| or | oder | ou | o | o | ou |
| countif | zahlenwenn | nbsi | contar.si | conta.se | cont.se |
| sumproduct | summenprodukt | summerprod | sumaproducto | matr.somma.prodotto | somarproduto |
| irr | ikv | tri | tir | tir.cost | tir |
| mirr | qikv | trim | tirm | tir.varr | mtir |
| npv | nbw | van | vna | van | vp |
| lookup | verweis | recherche | buscar | cerca | proc |
| pmt | rmz | vpm | pago | rata | pgto |
| ipmt | zinsz | intper | pagoint | interessi | ipgto |
| ppmt | kapz | princeper | pagoprin | p.rata | ppgato |
| today | heute | aujourdhui | hoy | oggi | hoje |
Excel Functions
Excel’s popularity has caused it to be translated into many different languages. While it is not difficult to use functionality on different language versions by going to the relevant location and clicking on a matching icon, translating the mathematical functions is a bit more obscure.
Below are translations for some of the more commong language versions. Please click on a function for a description and refer to Excel help or a Bayfield Training Course manual for more details. It is not an exhaustive list of functions. If you need any further help please feel free to contact us.
Note: Function syntax is always= NAMEOFFUNCTION(arguments)
The arguments required will be different for each function. Different arguments within a function are separted by commas in the UK and by a semi-colon in most other language versions.
| Function | Syntax | Description |
|---|---|---|
| SUM | =SUM(range) | The sum function adds all the numbers provided in the brackets. If the numbers are in separate locations they must be separated by commas (,) or semi-colons (;) Back to Excel Languages table |
| IF | =IF(test,true,false) | A logic functionwhich returns the formula/function/number entered into the true or false argument depending on the result of the test. The test itself therefore must return true or false.
Back to Excel Languages table |
| AND | =AND(tests) | A logic function comprised entirely of tests. If the tests are in separate locations they must be separated by commas (,) or semi-colons (;). The function returns true if all the tests are true, and false if any are false. (since this function returns true or false it is very useful in combination with the IF function)
Back to Excel Languages table |
| OR | =OR(tests) | A logic function comprised entirely of tests. The function returns true if any of the tests are true, and false only if all the tests are false.
Back to Excel Languages table |
| COUNTIF | =COUNTIF(range,criteria) | The COUNTIF function counts all the references in a given range that match a given criteria.
Back to Excel Languages table |
| SUMPRODUCT | =SUMPRODUCT(range1,range2) | Multiplies each successive pair from the two ranges, and then adds the resulting numbers. This can be extended to include more than two ranges.
Back to Excel Languages table |
| IRR | =IRR(cash flow) | The IRR function returns the Internal Rate or Return of a given cash flow. This is a very important, and often misused function in finance, please refer to one of our course manuals for more details on this.
Back to Excel Languages table |
| MIRR | =MIRR(cash flow, finance rate, reinvest rate) | The MIRR function returns the Modified Internal Rate of Return of a given cash flow.
Back to Excel Languages table |
| NPV | =NPV(discount rate, cash flow) | The NPV function returns the Net Present Value of a given cash flow, at a given discount rate. |
| LOOKUP | =LOOKUP(value,range1,range2) | Looks up a given value in range 1 and then returns the corresponding value in range 2. This function is very useful in the ‘event tables’ method of constructing complex cash flows.
Back to Excel Languages table |
| PMT | =PMT(rate, total period, loan) | PMT is short for Payment. It calculates the constant payment amount required to pay off a given loan and all interest at a given rate over a given period of time.
Back to Excel Languages table |
| IPMT | =IPMT(rate, period, total period, loan) | IPMT is short for Interest Payment. It calculates the interest due in any one period from the total period.
Back to Excel Languages table |
| PPMT | =PPMT(rate, period, total period, loan) | PPMT is short for Principle Payment. It calculates the capital repayment due in any one period from the total period.
Back to Excel Languages table |
| TODAY | =TODAY() | Returns today’s date, providing the clock on your computer is correctly set.
Back to Excel Languages table |