Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |