Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Found this on one of my worksheets ????
=G22/$E$22
I'm not sure what it does, can someone tell me. Thanks Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Found this on one of my worksheets ????
It takes the contents of cell G22 and divides them by the contents of cell
E22. If you copy this across to the right, the formula will then take the contents of cell H22 and divide by E22. This is because the dollar signs make E22 and asbolute reference that does not change when you copy the formula. G22 is called a relative refernce and always changes relative to the cell which has the formula. If this helps please click "Yes" <<<<<<<<<<< "Mike" wrote: =G22/$E$22 I'm not sure what it does, can someone tell me. Thanks Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Found this on one of my worksheets ????
It takes the contents of cell G22 and divides it by the contents of $E$22 and
displays those results in the cell with that formula. The difference between G22 and $E$22 is that $E$22 is an 'absolute' reference, meaning that if you were to insert new columns to the left of column E or above row 22, then the formula would then use the contents of the "new" E22 to do the division, but it would follow G22 to where ever it had moved to after the insertion or deletion of new rows/columns. "Mike" wrote: =G22/$E$22 I'm not sure what it does, can someone tell me. Thanks Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Found this on one of my worksheets ????
Thanks GUYS, I remember I was experminting with a formula and did not like
the results "JLatham" wrote: It takes the contents of cell G22 and divides it by the contents of $E$22 and displays those results in the cell with that formula. The difference between G22 and $E$22 is that $E$22 is an 'absolute' reference, meaning that if you were to insert new columns to the left of column E or above row 22, then the formula would then use the contents of the "new" E22 to do the division, but it would follow G22 to where ever it had moved to after the insertion or deletion of new rows/columns. "Mike" wrote: =G22/$E$22 I'm not sure what it does, can someone tell me. Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver.xla could not be found | Excel Discussion (Misc queries) | |||
File not found | Excel Discussion (Misc queries) | |||
Found part of what I need | Excel Discussion (Misc queries) | |||
IF NOT FOUND | Excel Worksheet Functions | |||
DMW_97.xla not found | Excel Discussion (Misc queries) |