Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can series tool change formulas over time when used to copy them
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. |
#2
|
|||
|
|||
Hi!
See this: http://tinyurl.com/azybg Read the entire thread. Biff "compu_trainer" wrote in message ... 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. |
#3
|
|||
|
|||
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 "Biff" wrote: Hi! See this: http://tinyurl.com/azybg Read the entire thread. Biff "compu_trainer" wrote in message ... 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. |
#4
|
|||
|
|||
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 "compu_trainer" wrote in message ... 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 "Biff" wrote: Hi! See this: http://tinyurl.com/azybg Read the entire thread. Biff "compu_trainer" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
Time Stamp-With Change | Excel Discussion (Misc queries) |