how to input a formula to add the next cell continuously using division. like
how to put a formula in one cell to add, subtract, divide and multiply and
then go to the next cell to do the same thing but use a different cell row
and cell column?

For better chances of better responses, elaborate what you mean, with
before/after examples. What formula do you have in which cell? And how do
you want it to propagate?

"angela" wrote in message
...
how to input a formula to add the next cell continuously using division.
like
how to put a formula in one cell to add, subtract, divide and multiply and
then go to the next cell to do the same thing but use a different cell row
and cell column?

Perhaps a simple example to illustrate ..
You could have this formula placed in C1: =SUM(A1:B1)
To copy C1 down to compute correspondingly the sums for A2:B2, A3:B3, etc,
just drag down the fill handle of C1 (that's the solid black square when you
point at the bottom right-corner of C1)

"angela" wrote:

how to input a formula to add the next cell continuously using division. like
how to put a formula in one cell to add, subtract, divide and multiply and
then go to the next cell to do the same thing but use a different cell row
and cell column?

What do you mean by add continuously using division?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"angela" wrote:

how to input a formula to add the next cell continuously using division. like
how to put a formula in one cell to add, subtract, divide and multiply and
then go to the next cell to do the same thing but use a different cell row
and cell column?