Reviewing the formula =+AD11/$Z$20, what does it mean?

[lance559]

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

[Niek Otten]

This could also be written without the "+" 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

"lance559" <[email protected]> wrote in message
news:[email protected]...
> Reviewing excel spreadsheet, what function is being formed by the
> following
> formula =+AD11/$Z$20 perform i.e, what does it mean?

[David Billigmeier]

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,
Dave


"lance559" wrote:

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

[Peo Sjoblom]

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

"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> This could also be written without the "+" 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
>
> "lance559" <[email protected]> wrote in message
> news:[email protected]...
> > Reviewing excel spreadsheet, what function is being formed by the
> > following
> > formula =+AD11/$Z$20 perform i.e, what does it mean?
>
>