View Single Post
  #2   Report Post  
Art
 
Posts: n/a
Default Can Excel evaluate a series of numbers

Can you just copy your formula? For example, let's suppose that the "one
number" is in cell C1. Suppose the other numbers are in A1 - A4. Finally
assume that your formula is in D1-G1.

Now, run down column C with the rest of the numbers. Then copy the formula
in D1-G1 down, next to the values in C. You'll need absolute references for
the values in A1-A4.


Art
"Chad Sellers" wrote:

I made an excel file to generate results from one number as the input a
couple of other fixed numbers to reference against and a couple of algebra
and quadratic equations to generate the desired answers. Can I make a list
of numbers in my excel file and have excel run through the equations already
set up and generate a list of results? If not, how do I make a file that
will step through a list of numbers, run excel on each and save the results
for each? Thank you, Chad Sellers