what is this formula means =+$R$16

  • Thread starter Thread starter mahmoud
  • Start date Start date
It anchors the row and column references, so that if you were to copy
that formula to any other cell it would still be:

=+$R$16

It is known as absolute referencing (check in XL Help for more
details).

Incidentally, you don't need the + sign in the formula.

Hope this helps.

Pete
 
Back
Top