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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com