copying formulas

B

Boz

What is the easiest way to copy formulas?

Basically I have a sheet that refers to set values per section which act as
a multiplier so I have a function that says '=(a4 * a2)' next one should be
'=(a5 * a2)' and so on. When I paste the formula in it goes to '=(a5 * a3)'.

Is there an easy way to remedy this situation?
 

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

Calculate end date and time 1
Dynamic pointing to a cell 0
Copy addition formula of non-consecutive horizontal cells 2
Return Unique Entries Only 6
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 6
get a cell reference as a result of an If Function 1
Copy a formula using Vlookup 2
Creating a formula relating to several cells 2

Top