<r>For example, TEMP_VAL = PUB_DATA_VECTOR(SROW, 1)For i = SROW + 1 To NROWS T_VAL = (PUB_DATE_VECTOR(i, 1) - PUB_DATE_VECTOR(SROW, 1)) / 365 TEMP_VAL = TEMP_VAL + (PUB_DATA_VECTOR(i, 1) / (1 + X_VAL) ^ T_VAL)Next iCALL_XIRR_OBJ_FUNC = Abs(TEMP_VAL) ^ 2 Recommend Newton or the Muller method in <URL ...