Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: changing values in function range for new value

Status
Not open for further replies.

wuhair

IS-IT--Management
Mar 9, 2003
16
US
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!
 
Where do you get these thousands of values from?

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

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

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]

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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top