Quote:
Originally posted by replicant_008
If you are using Excel you can view cells around the whole spreadsheet without leaving the cell that you are currently 'active' on. This is useful, for instance, if you are writing a spreadsheet with lots of columns and rows and you are tracing the precedent cells in a large formulae.
I have some modelling in an Excel spreadsheet with 4 'if' statements nested within the same formula (it works out bonuses and long service loadings) and it's useful to verify the independent variables that influence the result without moving from the cell with the formula...
|
And now I know what it does, thanks to another excellent post from replicant.
