formula

A

angela

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?
 
M

Max

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?
 
M

Max

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
need help with formula 4
Simple Division 1
Help needed 0
VLOOKUP 2
Formulas 1
formula problems 1

Top