I want to create a spreadsheet where some cell entries are mathematical
functions of data in corresponding cells (same row) of other columns. For
example, assume fixed data in columns A and B. In column C, I want C(1) to =
A(1) + B(1) etc.

Hi

in C1 type
=A1+B1
then move your cursor over the bottom right hand corner until you see a +
(known as the autofill handle)
hold the left mouse down and drag down the column as far as you need to go
and let go, the formula will be filled in for you for each line

Cheers
julieD

"S M Raucher" <S M wrote in message
...
I want to create a spreadsheet where some cell entries are mathematical
functions of data in corresponding cells (same row) of other columns. For
example, assume fixed data in columns A and B. In column C, I want C(1)
to =
A(1) + B(1) etc.

Just use a formula like the following in cell C1.

=A1+B1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"S M Raucher" <S M wrote in
message
...
I want to create a spreadsheet where some cell entries are
mathematical
functions of data in corresponding cells (same row) of other
columns. For
example, assume fixed data in columns A and B. In column C, I
want C(1) to =
A(1) + B(1) etc.