Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reviewing the formula =+AD11/$Z$20, what does it mean?
Reviewing excel spreadsheet, what function is being formed by the following
formula =+AD11/$Z$20 perform i.e, what does it mean? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reviewing the formula =+AD11/$Z$20, 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, 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reviewing the formula =+AD11/$Z$20, 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 "Niek Otten" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |