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