These are the 140 most common functions in Excel with Czech translations. This list is very useful if you are used to the English version of Excel, and you are working with a Czech version that only accepts the Czech function names in the formulas. Or the other way around!
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 |