copy formula and get value instead
I am using a sreadsheet created by someone else from a report file. I want
to calculate the difference between the amount in column A and the amount in
column B. When I enter the formula for each line separately, I get a correct
difference. When I copy the formula, the formula in the new cell looks right
but the value it returns is the value in the cell copied and not the result
of the formula. Any suggestions for correcting this?
|