please help with a function that I am unfamiliar with.

say a1=1 and b1= "=a1*2"

I then want a3, a4 and a5 to be 2, 3, 4 respectively, and
I want b3, b4, and b5 to be the b1 function above where
instead of a1 it would be a3, a4, a5 etc.... without
having to repoduce the equation in b3, b4, b5 and still
get the right answer.

i.e. In B3 I want to be able to write "if my input is A3,
into the equation written in b1, then my answer would
be ..."

Basically I have designed a formula that involves various
tabs, and I cant compress it into one cell to crunch 100
different inputs, and I want to be able to compare all
the different answers at the same time.

Thanks for the help.

So enter 1 into A1, and "=a1*2" into B1. Select both A1 and B2 by clicking
in the middle of A1 and drag to B1. Left-click and hold the lower right
corner of the selection (the small cross at the lower right of B1), and drag
down as far as you like. Then select the row header of A2, right-click the
and select Insert. Is that what you want?

"Steven." wrote in message
...
please help with a function that I am unfamiliar with.

say a1=1 and b1= "=a1*2"

I then want a3, a4 and a5 to be 2, 3, 4 respectively, and
I want b3, b4, and b5 to be the b1 function above where
instead of a1 it would be a3, a4, a5 etc.... without
having to repoduce the equation in b3, b4, b5 and still
get the right answer.

i.e. In B3 I want to be able to write "if my input is A3,
into the equation written in b1, then my answer would
be ..."

Basically I have designed a formula that involves various
tabs, and I cant compress it into one cell to crunch 100
different inputs, and I want to be able to compare all
the different answers at the same time.

Thanks for the help.

I mean, "Select both A1 and B1 by clicking...

"Bob Kilmer" wrote in message
...
So enter 1 into A1, and "=a1*2" into B1. Select both A1 and B2 by clicking
in the middle of A1 and drag to B1. Left-click and hold the lower right
corner of the selection (the small cross at the lower right of B1), and
drag
down as far as you like. Then select the row header of A2, right-click the
and select Insert. Is that what you want?

"Steven." wrote in message
...
please help with a function that I am unfamiliar with.

say a1=1 and b1= "=a1*2"

I then want a3, a4 and a5 to be 2, 3, 4 respectively, and
I want b3, b4, and b5 to be the b1 function above where
instead of a1 it would be a3, a4, a5 etc.... without
having to repoduce the equation in b3, b4, b5 and still
get the right answer.

i.e. In B3 I want to be able to write "if my input is A3,
into the equation written in b1, then my answer would
be ..."

Basically I have designed a formula that involves various
tabs, and I cant compress it into one cell to crunch 100
different inputs, and I want to be able to compare all
the different answers at the same time.

Thanks for the help.

I appreciate the help, but thats not really what I am
looking for.

I have a gigantic equation with links formulas etc... Say
there is only one variable, from 1 to 100. I want to
compare all the results together when x=1 to x=100. If I
write out 1 through 100 in seperate cells, and I then
want to put my result for each variable in the next cell
in all 100 cases. How do I write that out, as in
the "result" column, I can't squeeze this massize
equation into one cell.

Thanks again.
-----Original Message-----
I mean, "Select both A1 and B1 by clicking...

"Bob Kilmer" wrote in message
...
So enter 1 into A1, and "=a1*2" into B1. Select both
A1 and B2 by clicking
in the middle of A1 and drag to B1. Left-click and
hold the lower right
corner of the selection (the small cross at the lower
right of B1), and
drag
down as far as you like. Then select the row header of
A2, right-click the
and select Insert. Is that what you want?

"Steven." wrote
in message
...
please help with a function that I am unfamiliar
with.

say a1=1 and b1= "=a1*2"

I then want a3, a4 and a5 to be 2, 3, 4
respectively, and
I want b3, b4, and b5 to be the b1 function above
where
instead of a1 it would be a3, a4, a5 etc.... without
having to repoduce the equation in b3, b4, b5 and
still
get the right answer.

i.e. In B3 I want to be able to write "if my input
is A3,
into the equation written in b1, then my answer would
be ..."

Basically I have designed a formula that involves
various
tabs, and I cant compress it into one cell to crunch
100
different inputs, and I want to be able to compare
all
the different answers at the same time.

Thanks for the help.




.

you can generate the integers 1 to 100 in an array using Row(1:100)

so where your formula might use a variable

=1+2*A1

you could put

=sumproduct(1+2*row(1:100))

This sums the 100 different results.

A formula can have a length of 1024 characters if it were expressed in R1C1
format.

--
Regards,
Tom Ogilvy


wrote in message
...
I appreciate the help, but thats not really what I am
looking for.

I have a gigantic equation with links formulas etc... Say
there is only one variable, from 1 to 100. I want to
compare all the results together when x=1 to x=100. If I
write out 1 through 100 in seperate cells, and I then
want to put my result for each variable in the next cell
in all 100 cases. How do I write that out, as in
the "result" column, I can't squeeze this massize
equation into one cell.

Thanks again.
-----Original Message-----
I mean, "Select both A1 and B1 by clicking...

"Bob Kilmer" wrote in message
...
So enter 1 into A1, and "=a1*2" into B1. Select both
A1 and B2 by clicking
in the middle of A1 and drag to B1. Left-click and
hold the lower right
corner of the selection (the small cross at the lower
right of B1), and
drag
down as far as you like. Then select the row header of
A2, right-click the
and select Insert. Is that what you want?

"Steven." wrote
in message
...
please help with a function that I am unfamiliar
with.

say a1=1 and b1= "=a1*2"

I then want a3, a4 and a5 to be 2, 3, 4
respectively, and
I want b3, b4, and b5 to be the b1 function above
where
instead of a1 it would be a3, a4, a5 etc.... without
having to repoduce the equation in b3, b4, b5 and
still
get the right answer.

i.e. In B3 I want to be able to write "if my input
is A3,
into the equation written in b1, then my answer would
be ..."

Basically I have designed a formula that involves
various
tabs, and I cant compress it into one cell to crunch
100
different inputs, and I want to be able to compare
all
the different answers at the same time.

Thanks for the help.




.