Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
=(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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
Populate Array | Excel Programming | |||
populate array | Excel Programming | |||
populate chart array | Excel Programming | |||
Populate array | Excel Programming |