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 |