ExcelBanter - XIRR Function Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - XIRR Function Error (https://www.excelbanter.com/excel-worksheet-functions/5452-xirr-function-error.html)

Vince

XIRR Function Error

Hi there,

I am trying to create a sensitivity table that is driven off the XIRR
function. I get some positive values, a neg. value and mostly #NUM!. Can
someone please help?

Myrna Larson

Have you followed the "rules" for the XIRR function WRT to the first date, the
signs of the values, and the guess? They are pretty well explained in Help for
the function.

On Mon, 1 Nov 2004 12:49:02 -0800, "Vince"
wrote:

Hi there,

I am trying to create a sensitivity table that is driven off the XIRR
function. I get some positive values, a neg. value and mostly #NUM!. Can
someone please help?

All times are GMT +1. The time now is 04:39 PM.