Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate an array that is a subset of a larger array? Jeff Excel Worksheet Functions 1 September 25th 07 12:51 AM
Populate Array Dale Excel Programming 1 April 6th 06 01:06 AM
populate array Marina Limeira Excel Programming 3 January 20th 06 05:55 PM
populate chart array John Excel Programming 2 February 19th 04 04:46 AM
Populate array Beto[_3_] Excel Programming 6 December 30th 03 09:53 PM


All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"