(C) 2012 - 2019 by Mourad Louha · All rights reserved.
Privacy  ·  Imprint

TRUNC

The english function name TRUNC() has been translated into 16 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 VersionsAvailabilityCategory
Excel 2016YesMath. & Trig.
Excel 2013YesMath. & Trig.
Excel 2010YesMath. & Trig.
Excel 2007YesMath. & Trig.
Excel 2003YesMath. & Trig.

Reference language

LanguageDesignation
EnglishTRUNC

Translations

LanguageDesignation
CzechUSEKNOUT
DanishAFKORT
DutchGEHEEL
FinnishKATKAISE
FrenchTRONQUE
GermanKÜRZEN
HungarianCSONK
ItalianTRONCA
NorwegianAVKORT
PolishLICZBA.CAŁK
Portuguese, BrazilTRUNCAR
Portuguese, PortugalTRUNCAR
RussianОТБР
SpanishTRUNCAR
SwedishAVKORTA
TurkishNSAT

Different translations for Excel 2010 SP1

LanguageDesignation
BasqueTRUNKATU
GalicianTRUNCAR

Different translations for Excel 2010

LanguageDesignation
BasqueTRUNKATU
GalicianTRUNCAR
Portuguese, BrazilTRUNC

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.

Language   
ArabicFinnishKazakhRussian
BasqueFrenchKonkaniSerbian
BulgarianGalicianKoreanSlovak
CatalanGermanLatvianSlovenian
Chinese - SimplifiedGreekLithuanianSpanish
Chinese - TraditionalGujaratiMalaysianSwedish
CroatianHebrewMarathiThai
CzechHindiNorwegianTurkish
DanishHungarianPolishUkrainian
DutchIndonesianPortuguese, BrazilVietnamese
EnglishItalianPortuguese, Portugal-
EstonianJapaneseRomanian-