| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
in my spreadsheet when i fill down the formula i want it to use one cell and
mulitply it by the row. How do i do this, please help its driving me mad! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
tRY THIS AND DRAG DOWN
=$A$1*A2 mIKE "Coolchick" wrote: in my spreadsheet when i fill down the formula i want it to use one cell and mulitply it by the row. How do i do this, please help its driving me mad! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
Use
=A$1*A2 and fill down -- Kind regards, Niek Otten Microsoft MVP - Excel "Coolchick" wrote in message ... | in my spreadsheet when i fill down the formula i want it to use one cell and | mulitply it by the row. | | How do i do this, please help its driving me mad! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
Go into Excel help and look at the difference between absolute and relative
addressing for cell references. -- David Biddulph "Coolchick" wrote in message ... in my spreadsheet when i fill down the formula i want it to use one cell and mulitply it by the row. How do i do this, please help its driving me mad! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula filling | Excel Worksheet Functions | |||
| Formula filling???? | Excel Worksheet Functions | |||
| help with filling in an array formula | Excel Discussion (Misc queries) | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
| Filling Down Formula | Excel Discussion (Misc queries) | |||
Linear Mode
