Hello,
I'm trying to do an analysis using the IRR function.
I have a cashflow for example:
IRR(A1:A4,0.01)
where
A1:A4 =
-100
20
50
60
now i want to some how be able to have a list of numbers to replace the "-100" and get there resuts of the IRR calculation.
Like replacing the "-100" with "-50","-60" etc. It would be like:
A1:A4 =
-50
20
50
60
OR...
A1:A4 =
-50
20
50
60
I can't simply make a bunch of colums of similar data and just change the "-100" to other values cause i have thousands of values to plug in a replace.
Please let me know if there's a way to do this. thanks!
I'm trying to do an analysis using the IRR function.
I have a cashflow for example:
IRR(A1:A4,0.01)
where
A1:A4 =
-100
20
50
60
now i want to some how be able to have a list of numbers to replace the "-100" and get there resuts of the IRR calculation.
Like replacing the "-100" with "-50","-60" etc. It would be like:
A1:A4 =
-50
20
50
60
OR...
A1:A4 =
-50
20
50
60
I can't simply make a bunch of colums of similar data and just change the "-100" to other values cause i have thousands of values to plug in a replace.
Please let me know if there's a way to do this. thanks!