Thread: Cell reference within array
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Cell reference within array
Glenn wrote:
wrote:
On May 4, 3:53 pm, wrote:
I am trying to use a cell reference within an array, but Excel won't
let me.

In my case, here is the formula I want: =IRR(A8,50,50,50,50)

A8 is a negative number that will change by row: the next line would
read =IRR(A9,50,50,50,50)

Ideas?

Nothing?


Put 50 in B8:E8 (you can hide those columns) and use this:

=IRR(A8:E8)

Or, put 50 in cell A1. Select cell A8, then Insert / Name / Define "ARRAY" as
follows:

=Sheet1!$A8,Sheet1!$A$1,Sheet1!$A$1,Sheet1!$A$1,Sh eet1!$A$1

Then use this:

=IRR(ARRAY)
Reply With QuoteReply With Quote