The english function name TRUNC() has been translated into 18 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
Availability
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Math. & Trig. |
| Excel 2013 | Yes | Math. & Trig. |
| Excel 2010 | Yes | Math. & Trig. |
| Excel 2007 | Yes | Math. & Trig. |
| Excel 2003 | Yes | Math. & Trig. |
Reference language
| Language | Designation |
|---|---|
| English | TRUNC |
Translations
| Language | Designation |
|---|---|
| Basque | TRUNKATU |
| Czech | USEKNOUT |
| Danish | AFKORT |
| Dutch | GEHEEL |
| Finnish | KATKAISE |
| French | TRONQUE |
| Galician | TRUNCAR |
| German | KÜRZEN |
| Hungarian | CSONK |
| Italian | TRONCA |
| Norwegian | AVKORT |
| Polish | LICZBA.CAŁK |
| Portuguese, Brazil | TRUNCAR |
| Portuguese, Portugal | TRUNCAR |
| Russian | ОТБР |
| Spanish | TRUNCAR |
| Swedish | AVKORTA |
| Turkish | NSAT |
Different translations for Excel 2010
| Language | Designation |
|---|---|
| Portuguese, Brazil | TRUNC |
Links to the Microsoft Online Help for the function TRUNC()
Note: Microsoft is currently updating the links and contents for the Excel online help. Therefore, some of the following links may not work as expected and lead to an error page. The links will on this site will be updated as soon as possible.