Hi all,
I need an IRR of 1% and use this formula in cell B1: =IF(A1<1%;"x";0)
Now I need to figure out what amount to add in cell B1 to get the IRR up to 1%.
Assume the IRR data is in cells C1 to C10 (dates) and D1 to D10 (amounts).
Does anyone know how to put this in the formula?
Thanks!
Rob
I need an IRR of 1% and use this formula in cell B1: =IF(A1<1%;"x";0)
Now I need to figure out what amount to add in cell B1 to get the IRR up to 1%.
Assume the IRR data is in cells C1 to C10 (dates) and D1 to D10 (amounts).
Does anyone know how to put this in the formula?
Thanks!
Rob