Excel: changing values in function range for new value

[wuhair]

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!

 

[ETID]

Where do you get these thousands of values from?

 

[KenWright]

Try looking in help for a 'One Variable Data Table'

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[wuhair]

I figured it out you can do a range like this =irr((a1,a3:a5),0.01)