View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Reviewing the formula =+AD11/$Z$20, what does it mean?

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" wrote in message
...
Reviewing excel spreadsheet, what function is being formed by the
following
formula =+AD11/$Z$20 perform i.e, what does it mean?