Can series tool change formulas over time when used to copy them

C

compu_trainer

During a full audit, random errors were found in the formula in large
spreadsheets. The formula was copied down the columns using the series
(sequencing) tool. Can this tool at some point in time assume a sequence and
change the formula in such a subtle way that it is not detected until a full
audit on the spreadsheet data is performed.
 
C

compu_trainer

Thanks for the info Biff, I think that what you are confirming is when
copying formulas, by using the series tool instead of copy and paste
function, the formula can change by a decimal point randomly thereby giving
an incorrect answer in large spreadsheets. Which is what I suspect is
happening. Is that correct?

Compu_Trainer
 
B

Biff

Hi!

It is certainly possible and dependant upon many factors. The example I
referred to is proof of that. I did not expect that possibility!

Biff
 
Top