cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel function arguments for ISPMT in German and its corresponding online help article

Excel function arguments for ISPMT in German and its corresponding online help article
1

Upvotes

Upvote
 Feb 08 2018
6 Comments (6 New)
Completed

Hi there,

 

I rarely use financial functions, but discovered today that the function arguments for ISPMT are untranslated (if not intentionally) for the German Excel Version 2016 and for Excel 2010 too.

 

The Excel Online Help states other argument names than displayed in the Excel function assistant, for example. The online article respectively translates the arguments rate, per, nper, pv to Zins, Zr, Zzr and Bw.

 

image.png

 

 

Additionally, the German version of the online article has an error, as it indicates the additional optional parameters [Zw] and [F] in the syntax: ISPMT(Zins;Zr;Zzr;Bw;[Zw];[F]). The two last arguments are not available for this function.

 

Best,

Mourad

Comment
Comments
Stafford Quaid
Microsoft
‎Feb 08 2018 09:52 AM
‎Feb 08 2018 09:52 AM

Thanks for pointing that out @Deleted. We will have our Excel Localisation PM investigate and report back in our PowerBI Dashboard. Regards, Stafford 

Allen Smith
Copper Contributor
‎Oct 01 2018 08:55 AM
‎Oct 01 2018 08:55 AM
Status changed to: Working on it
 
Stafford Quaid
Microsoft
‎Nov 29 2018 04:25 AM
‎Nov 29 2018 04:25 AM

Hi @Mourad-Louha

Just letting you know the Excel Loc PM does not want to change this as it is legacy. If you feel the content page should still be improved please submit another idea and we will action it. 

Regards,

Staff

 

Stafford Quaid
Microsoft
‎Nov 29 2018 04:26 AM
‎Nov 29 2018 04:26 AM
Status changed to: Completed
 
Mourad-Louha
MVP
‎Nov 29 2018 05:30 AM
‎Nov 29 2018 05:30 AM

Hi Stafford,

thanks - I understand that, as ISPMT is legacy, a change should be avoided. However, as you recommended, I will post a new thread regarding the online help article, as there is an error there.

 

Best,

Mourad

sfumis
Copper Contributor
‎May 13 2020 09:44 AM
‎May 13 2020 09:44 AM

¿Hay un error en la funcion INT.PAGO.DIR (español) = ISPMT (inglés)?

Esta función y los ejemplos en la ayuda online y en F1 (Excel function assistant), establecen que la variable Per debe estar entre 1 y NPer, sin embargo admite valores como 0 o superiores a NPer.

Además, el valor para Per=2 devuelve el valor de Per=1, y así sucesivamente, en relación a lo mostrado en las imagenes publicadas en:

https://support.office.com/es-es/article/int-pago-dir-funci%C3%B3n-int-pago-dir-fa58adb6-9d39-4ce0-8...

y en

https://support.office.com/en-us/article/ispmt-function-fa58adb6-9d39-4ce0-8f43-75399cea56cc?ui=en-U...

 

Similar Ideas
No similar ideas