Cell Adduction
Comparative adduction

Indicates the comparative location of a cell that contains data selection

Absolute adduction

We can add $ in front of any adduction if we need the adduction unchanged, by this way, we can use an absolute adduction to a cell.

This example contains three kinds of correct absolute adduction. “$C$1:” won't change when we copy it to another cell. The “A” in “$A1:” won't change, but “ 1” will. The “B” in “B$1:” will change but “ 1” won't.

 
 
©2003-2005 RUNFAR, Inc. All rights reserved.