The english function name YEAR() has been translated into 19 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Date & Time |
| Excel 2013 | Yes | Date & Time |
| Excel 2010 | Yes | Date & Time |
| Excel 2007 | Yes | Date & Time |
| Excel 2003 | Yes | Date & Time |
| Language | Designation |
|---|---|
| English | YEAR |
The english function name YEARFRAC() has been translated into 17 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Date & Time |
| Excel 2013 | Yes | Date & Time |
| Excel 2010 | Yes | Date & Time |
| Excel 2007 | Yes | Date & Time |
| Excel 2003 | No | - |
| Language | Designation |
|---|---|
| English | YEARFRAC |
The english function name YIELD() has been translated into 17 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Financial |
| Excel 2013 | Yes | Financial |
| Excel 2010 | Yes | Financial |
| Excel 2007 | Yes | Financial |
| Excel 2003 | No | - |
| Language | Designation |
|---|---|
| English | YIELD |
The english function name YIELDDISC() has been translated into 17 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Financial |
| Excel 2013 | Yes | Financial |
| Excel 2010 | Yes | Financial |
| Excel 2007 | Yes | Financial |
| Excel 2003 | No | - |
| Language | Designation |
|---|---|
| English | YIELDDISC |
The english function name YIELDMAT() has been translated into 17 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Financial |
| Excel 2013 | Yes | Financial |
| Excel 2010 | Yes | Financial |
| Excel 2007 | Yes | Financial |
| Excel 2003 | No | - |
| Language | Designation |
|---|---|
| English | YIELDMAT |
The english function name Z.TEST() has been translated into 11 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Statistical |
| Excel 2013 | Yes | Statistical |
| Excel 2010 | Yes | Statistical |
| Excel 2007 | No | - |
| Excel 2003 | No | - |
| Language | Designation |
|---|---|
| English | Z.TEST |
The english function name ZTEST() has been translated into 14 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Compatibility |
| Excel 2013 | Yes | Compatibility |
| Excel 2010 | Yes | Compatibility |
| Excel 2007 | Yes | Statistical |
| Excel 2003 | Yes | Statistical |
| Language | Designation |
|---|---|
| English | ZTEST |