gh05
09-11-2010, 07:31 PM
Is there a way to stop a spreadsheet from executing further calculations if a certain condition is met? Example:
Suppose I enter the value 1 in cell A1 and a formula to increment by 1 in cell A2 ... i.e. =A1+1 ... and drag the formula down the first 50 cells to A50 so that the formula in cell A50 is =A49+1. How can I edit the formula in cell A2 (to be dragged down the first 50 cells to cell A50 as above) so that the calculation terminates after printing out the numbers 1 to 20 in cells A1 to A20, even though there are still formulae in cells A21 to A50 inclusive?
Thanks!
GH
Suppose I enter the value 1 in cell A1 and a formula to increment by 1 in cell A2 ... i.e. =A1+1 ... and drag the formula down the first 50 cells to A50 so that the formula in cell A50 is =A49+1. How can I edit the formula in cell A2 (to be dragged down the first 50 cells to cell A50 as above) so that the calculation terminates after printing out the numbers 1 to 20 in cells A1 to A20, even though there are still formulae in cells A21 to A50 inclusive?
Thanks!
GH