Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
OK, try the following.
The $A1 reference means that column A is locked or fixed. This means that if you copy a formula, to the right, it will alsways use the values from column A, but copying down, it will move down the row references. If it read A$1, then it means that Row 1 is locked. If you copy the formula down rows, it will always use the cells from the row. If you copy the formula o the right, the column references will update Setup a sheet looking like this A B C D 1 10% 20% 30% 2 10 =$A1*b$1 3 20 4 30 Copy the formula down and to the right, and look at the column and row references Hope this helps Eddie -- "ET" wrote: Sorry, having trouble understanding $A etc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
Lookup function help | Excel Worksheet Functions | |||
Should be really easy lookup ! | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |