| 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 |
| 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) | |||
Threaded Mode
