Populate an array using a formula

  • Thread starter Thread starter lindsay.hawke
  • Start date Start date
L

lindsay.hawke

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.
 
=(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.
 
Back
Top