software

Reviewing excel spreadsheet, what function is being formed by the following
formula = AD11/$Z$20 perform i.e, what does it mean?

It is dividing the value in cell AD11 by the value in cell Z20.

The $'s around the Z20 mean that if you drag or copy that formula to another
cell, the reference of AD11 will change but Z20 will remain (an absolute
reference).

--
Regards,
Davequot;lance559quot; wrote:

gt; Reviewing excel spreadsheet, what function is being formed by the following
gt; formula = AD11/$Z$20 perform i.e, what does it mean?

This could also be written without the quot; quot; sign

It means that the cell where the formula resides will show the result of
dividing the value of the cell AD11 by the value of the cell Z20.
The $ signs in the second reference mean that if the formula is copied to
other cells, Z20 will remain Z20; it will not adjust to the relative
position of the cell where it is copied to, as the AD11 part will.

--
Kind regards,

Niek Otten

quot;lance559quot; gt; wrote in message
...
gt; Reviewing excel spreadsheet, what function is being formed by the
gt; following
gt; formula = AD11/$Z$20 perform i.e, what does it mean?
The plus most likely means it was originally written in Lotus 123 or at
least the person who wrote it came from using Lotus 123

--

Regards,

Peo Sjoblom

quot;Niek Ottenquot; gt; wrote in message
...
gt; This could also be written without the quot; quot; sign
gt;
gt; It means that the cell where the formula resides will show the result of
gt; dividing the value of the cell AD11 by the value of the cell Z20.
gt; The $ signs in the second reference mean that if the formula is copied to
gt; other cells, Z20 will remain Z20; it will not adjust to the relative
gt; position of the cell where it is copied to, as the AD11 part will.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;lance559quot; gt; wrote in message
gt; ...
gt; gt; Reviewing excel spreadsheet, what function is being formed by the
gt; gt; following
gt; gt; formula = AD11/$Z$20 perform i.e, what does it mean?
gt;
gt;