These are the most common Excel functions with Czech translations.
Funkce aplikace Excel v ceštine
Normally you would also have to replace all the commas in my example formulas with semi-colon.
English | Czech |
---|---|
ABS | ABS |
ADDRESS | ODKAZ |
AGGREGATE | AGGREGATE |
AND | A |
ARABIC | ARABIC |
AVERAGE | PRŮMĚR |
AVERAGEIF | AVERAGEIF |
AVERAGEIFS | AVERAGEIFS |
BAHTTEXT | BAHTTEXT |
BIN2DEC | BIN2DEC |
BIN2HEX | BIN2HEX |
CEILING | ZAOKR.NAHORU |
CEILING.MATH | CEILING.MATH |
CELL | POLÍČKO |
CHAR | ZNAK |
CHOOSE | ZVOLIT |
CODE | KÓD |
COLUMN | SLOUPEC |
COLUMNS | SLOUPCE |
CONCAT | CONCAT |
CONCATENATE | CONCATENATE |
CONVERT | CONVERT |
COUNT | POČET |
COUNTA | POČET2 |
COUNTBLANK | COUNTBLANK |
COUNTIF | COUNTIF |
COUNTIFS | COUNTIFS |
DATE | DATUM |
DATEVALUE | DATUMHODN |
DAY | DEN |
DAYS | DAYS |
DEC2BIN | DEC2BIN |
DEC2HEX | DEC2HEX |
EOMONTH | EOMONTH |
EVEN | ZAOKROUHLIT.NA.SUDÉ |
EXACT | STEJNÉ |
FACT | FAKTORIÁL |
FILTERXML | FILTERXML |
FIND | NAJÍT |
FLOOR | ZAOKR.DOLŮ |
FLOOR.MATH | FLOOR.MATH |
FORMULATEXT | FORMULATEXT |
FREQUENCY | ČETNOSTI |
HEX2BIN | HEX2BIN |
HEX2DEC | HEX2DEC |
HLOOKUP | VVYHLEDAT |
HYPERLINK | HYPERTEXTOVÝ.ODKAZ |
IF | KDYŽ |
IFERROR | IFERROR |
IFS | IFS |
INDEX | INDEX |
INDIRECT | NEPŘÍMÝ.ODKAZ |
INFO | O.PROSTŘEDÍ |
INT | CELÁ.ČÁST |
ISBLANK | JE.PRÁZDNÉ |
ISERROR | JE.CHYBHODN |
ISEVEN | ISEVEN |
ISLOGICAL | JE.LOGHODN |
ISNA | JE.NEDEF |
ISNONTEXT | JE.NETEXT |
ISNUMBER | JE.ČISLO |
ISODD | ISODD |
ISOWEEKNUM | ISOWEEKNUM |
ISTEXT | JE.TEXT |
LARGE | LARGE |
LEFT | ZLEVA |
LEN | DÉLKA |
LOOKUP | VYHLEDAT |
LOWER | MALÁ |
MATCH | POZVYHLEDAT |
MAX | MAX |
MAXIFS | MAXIFS |
MEDIAN | MEDIAN |
MID | ČÁST |
MIN | MIN |
MINIFS | MINIFS |
MOD | MOD |
MODE | MODE |
MONTH | MĚSÍC |
MROUND | MROUND |
N | N |
NA | NEDEF |
NETWORKDAYS | NETWORKDAYS |
NETWORKDAYS.INTL | NETWORKDAYS.INTL |
NOT | NE |
NOW | NYNÍ |
ODD | ZAOKROUHLIT.NA.LICHÉ |
OFFSET | POSUN |
OR | NEBO |
PERCENTILE | PERCENTIL |
PERCENTILE.EXC | PERCENTIL.EXC |
PERCENTILE.INC | PERCENTIL.INC |
PERCENTRANK | PERCENTRANK |
PERCENTRANK.EXC | PERCENTRANK.EXC |
PERCENTRANK.INC | PERCENTRANK.INC |
PI | PI |
PMT | PLATBA |
PROPER | VELKÁ2 |
QUARTILE | QUARTIL |
QUARTILE.EXC | QUARTIL.EXC |
QUARTILE.INC | QUARTIL.INC |
RAND | NÁHČÍSLO |
RANDBETWEEN | RANDBETWEEN |
RANK | RANK |
RANK.AVG | RANK.AVG |
RANK.EQ | RANK.EQ |
REPLACE | NAHRADIT |
REPT | OPAKOVAT |
RIGHT | ZPRAVA |
ROMAN | ROMAN |
ROUND | ZAOKROUHLIT |
ROUNDDOWN | ROUNDDOWN |
ROUNDUP | ROUNDUP |
ROW | ŘÁDEK |
ROWS | ŘÁDKY |
SEARCH | HLEDAT |
SMALL | SMALL |
STDEV | SMODCH.VÝBĚR |
STDEV.P | SMODCH.P |
STDEV.S | SMODCH.VÝBĚR.S |
SUBSTITUTE | DOSADIT |
SUBTOTAL | SUBTOTAL |
SUM | SUMA |
SUMIF | SUMIF |
SUMIFS | SUMIFS |
SUMPRODUCT | SOUČIN.SKALÁRNÍ |
SWITCH | SWITCH |
TEXT | HODNOTA.NA.TEXT |
TEXTJOIN | TEXTJOIN |
TODAY | DNES |
TRANSPOSE | TRANSPOZICE |
TRIM | PROČISTIT |
UNICHAR | UNICHAR |
UNICODE | UNICODE |
UPPER | VELKÁ |
VLOOKUP | SVYHLEDAT |
WEEKDAY | DENTÝDNE |
WEEKNUM | WEEKNUM |
YEAR | ROK |
FALSE | NEPRAVDA |
TRUE | PRAVDA |