| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill with one part of the formula refering to a constant cell
how do I use autofill if part of the formula refers to one cell and all other
other calculations down the row refer to that same cell? eg Cell D1 is =C1/C10*100 Cell D2 is =C2/C10*100 Cell D3 is =C3/C10*100 -- old grey whiskers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill with one part of the formula refering to a constant cell
Enter this in D1 and just copy down:
=C1/C$10*100 The $ "locks" the row number. Likewise, if you were to drag copy across: =C1/$C10*100 The $ "locks" the column letter. You can "mix and match" in any combination depending on your needs. Biff "old grey whiskers" wrote in message ... how do I use autofill if part of the formula refers to one cell and all other other calculations down the row refer to that same cell? eg Cell D1 is =C1/C10*100 Cell D2 is =C2/C10*100 Cell D3 is =C3/C10*100 -- old grey whiskers |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill with one part of the formula refering to a constant c
ripper , I knew it could't be that difficult to do. thankyou
-- old grey whiskers "Biff" wrote: Enter this in D1 and just copy down: =C1/C$10*100 The $ "locks" the row number. Likewise, if you were to drag copy across: =C1/$C10*100 The $ "locks" the column letter. You can "mix and match" in any combination depending on your needs. Biff "old grey whiskers" wrote in message ... how do I use autofill if part of the formula refers to one cell and all other other calculations down the row refer to that same cell? eg Cell D1 is =C1/C10*100 Cell D2 is =C2/C10*100 Cell D3 is =C3/C10*100 -- old grey whiskers |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill with one part of the formula refering to a constant c
You're welcome!
Biff "old grey whiskers" wrote in message ... ripper , I knew it could't be that difficult to do. thankyou -- old grey whiskers "Biff" wrote: Enter this in D1 and just copy down: =C1/C$10*100 The $ "locks" the row number. Likewise, if you were to drag copy across: =C1/$C10*100 The $ "locks" the column letter. You can "mix and match" in any combination depending on your needs. Biff "old grey whiskers" wrote in message ... how do I use autofill if part of the formula refers to one cell and all other other calculations down the row refer to that same cell? eg Cell D1 is =C1/C10*100 Cell D2 is =C2/C10*100 Cell D3 is =C3/C10*100 -- old grey whiskers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| How do I set one cell as a constant so I can drag the formula | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| how do I use a cell value as part of a cell refereren in a formula | Excel Worksheet Functions | |||
| How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) | |||
Linear Mode
