what is this formula means =+$R$16

P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft 365 Activations, Users or Devices? 0
Finding dates without attention to data formats 3
Sumproduct formula problem 5
Finding location (or start cell) of highest consecutive values 3
Cannot access to Office Insider 0
Autofilling Alpha-Numeric numbers with column headers 1
Percentage of month passed formula 1
Copy addition formula of non-consecutive horizontal cells 2

Top