Can Excel evaluate a series of numbers
It would be difficult to try this. I have the input number at A2. Two
numbers at A5 and A^ are used to get an area and perimeter in A7 and A8. I
multiply these by the input in A2 and save at G7 and G8. Then the quadratic
result is placed at G12 and G13. These are rounded so the results I want are
at A12 and A13 with an error also wanted calculated and placed at A15 and
E15. What I would like to do is run a list of numbers placed at B19-48 as
if they resided at A2 and save the results from A12, A13, A15 and E15 to C-F
: 19-48 respectively..
"Art" wrote:
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
|