Populate an array using a formula
 

I am trying to use a formula that references a specific spot in an
array to fill in that array. If the cell is in the 3rd row and 4th
column, it would take a value (x) and raise it to the 3rd power and add
that to a value (y) and raise it to the 4th power. I have been reading
books and posts and am stuck.

Populate an array using a formula
 

=(D3^3+Y)^4

replace Y with whatever value you want.

Otherwise, be more specific in your description. You talk about an array,
then say cell. You posted in Programming and then talk about a formula.

It is unclear if x is the value in the 3rd row and 4th column of whatever
you mean by array and you don't say what y is.

--
regards,
Tom Ogilvy




wrote in message
oups.com...
I am trying to use a formula that references a specific spot in an
array to fill in that array. If the cell is in the 3rd row and 4th
column, it would take a value (x) and raise it to the 3rd power and add
that to a value (y) and raise it to the 4th power. I have been reading
books and posts and am stuck.