XIRR question

Hi,

I’m sorry, but I don’t understand your question.

If you want add the “%” symbol at the end of the equation’s result, you simply should enter the symbol in the attribute: “Symbol to display at the end of calculated field”

Best regards.

I’m getting an answer like”0.41, when back of the napkin calculations tell me it should be 41%. In other words, if I want to know what percent of 8 that 3 represents, the calculation would (3/8)*100″%” = (.375)*100= 37.5%

If I’m not mistaken, the XIRR function is leaving off that last “*100”.

Hi,

If you want to know the 3 percent of the number 8, the equation is as you describe:

(function(){
return (3/8*100)+'%';
})()

or simply:

3/8*100

and enter the symbol “%” through the attribute: “Symbol to display at the end of calculated field” of the calculated field.

Best regards.

missing my point. XIRR should be presented as a percentage. Since the XIRR function isn’t doing that, and is always (so far as I can tell), coming up with a decimal number less than 1.0, I believe that it is skipping the last step in any percentage calculation which is “multiply by 100”.

Hi,

Both solutions are valid, please, check the function documentation in the following links:

https://support.office.com/en-us/article/XIRR-function-de1242ec-6477-445b-b11b-a303ad9adc9d

https://help.libreoffice.org/Calc/Financial_Functions_Part_Three#Example_2

https://support.google.com/docs/answer/3093266?hl=en

If you want get the result as a percentage value, simply multiply the result by 100

Best regards.

gotcha. thank you…