Sorry, pl dismiss the earlier suggestion.
Ref your orig. post, I wasn't even able to get either
of the expressions below that you mentioned working:
=IRR(($D$49,OFFSET($C$40:$AZ$47,1,1,1,6),$D$50))
=IRR((Flows!$D$49,OFFSET(Flows!$C$40:$AZ$47,1,1,1, 6),Flows!$D$50))
Hang around for better insights from others ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
Hmmm.. that doesn't work for me. I can't have C4 contain the text
"Flows!$D$49", because I'd essentially be replicating the "Flows" sheet
in the current sheet (there are many cells that I'm trying to do this
for).
The call I need to make is something like:
=IRR((C4, OFFSET(Flows!$C40:$AZ$47,1,1,1,6),Flows!$D$50))
Trying:
=IRR((INDIRECT("C4"), OFFSET(Flows!$C40:$AZ$47,1,1,1,6),Flows!$D$50))
doesn't work either...
any other suggestions??