Creating a table from a formula

F

Fiend

I want to enter a formula in excel and then create an automatic table
from that formula with a certain range. I'm not quite sure how to do
it, though.
If I were to enter the formula: E(T)=(600T^2)-(255900T)+(27284400) in
A1 how could I get a list of numbers for when T=200, T=201, T=202, etc.
up to 214?
Help would be appreciated, thanks.
 
K

Ken Johnson

Hi Fiend,
This is just one of several ways:
In B1 type 200.
In B2 type =B1 + 1
Position the cursor over the bottom right corner of B2. The cursor
should change to a finer cross called the fill handle. With the fill
handle visible, click and drag down to B15.
In A1 type =600*B1^2 - 255900*B1 + 277284400
Press Enter and the formula disappears, only to be replaced by
250104400
Position the cursor over the bottom right corner of A1 to get the
fillhandle again then click and drag down to A15.

Traditionally the independent variable (your T) is in the left column,
but I don't want to argue about.

Ken Johnson
 
Top