Hello all,
I am trying to calculate an XIRR based on a series of dates and cash flows, the issue I am running into is that the blank cells are producing a !value error which I am trying to overcome.
I am populating 2 separate columns based on a distribution/capital call table which is pulling the dates and producing a blank cell if there is no date
=IF(J95="netted from next call","",IF(OR(F95="Capital call",F95="both",F95="distribution",F95="deemed"),IF(J95=0,I95,J95),""))
Same procedure with the cash amounts
=IF(K38=0,"",K38)
The bottom row is a pull for a quarter end date and current NAV values as seen below:
I am hoping there is a way to auto populate the formula so that the XIRR function will pull correctly based empty rows between the latest cashflows/dates and final cashflow/date.
I am trying to calculate an XIRR based on a series of dates and cash flows, the issue I am running into is that the blank cells are producing a !value error which I am trying to overcome.
I am populating 2 separate columns based on a distribution/capital call table which is pulling the dates and producing a blank cell if there is no date
=IF(J95="netted from next call","",IF(OR(F95="Capital call",F95="both",F95="distribution",F95="deemed"),IF(J95=0,I95,J95),""))
Same procedure with the cash amounts
=IF(K38=0,"",K38)
The bottom row is a pull for a quarter end date and current NAV values as seen below:
I am hoping there is a way to auto populate the formula so that the XIRR function will pull correctly based empty rows between the latest cashflows/dates and final cashflow/date.