copying formulas
thanks for your reply. I do not want the formula to always refer to the same
cell. I need them to refer to the row above. Everytime I try to copy the
formula to more than one cell i get "#VALUE" in all the cells
"Franz Verga" wrote:
Woody wrote:
how do I copy a formula i.e. =K64-M65 into all cells in a row
If you want that the formula referers always to the same cells, you have to
use absolute references, i.e. you have to insert the formula in this way:
=$K$64-$M$65
the you can drag the cell with the formula...
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|