Page 22 - iPro_trackGPT_V5_Class8
P. 22

When you copy the formula to another cell, the reference to cell B9 will stay constant and would
                  not change, as illustrated:
































                          Tech Tweak

                    Pressing the F4 key repeatedly over a cell reference in a formula allows you to cycle through
                    different types of cell references.


                  Mixed References

                  A mixed reference is a combination of relative and absolute references. It lets you lock either a
                  row or a column while keeping the other part adjustable. To make a mixed reference, use the
                  Dollar ($) symbol to fix either the row or the column.



                    20    TrackGPT iPRO (V5.0)-VIII
   17   18   19   20   21   22   23   24   25   26   27