| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use the number in one cell for different formulas
when I copy and paste the formula I want into adjacent cells, it does not
retain the particular cell I want to use. I had to input each formula manually. How do I keep using the one cell I need as part of the formula, as the divisor? i.e., sum=(a1)/(f12), keeping a1 as the constant divisor, no matter what other cell I use (b7) for example??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
use the number in one cell for different formulas
Use the "$" signs to fix the cell reference
Eg if you have it in G12 as: =A1/$F$12, then when you copy G12 and paste it elsewhere, the divisor (cell F12) will not change -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "RlR" wrote: when I copy and paste the formula I want into adjacent cells, it does not retain the particular cell I want to use. I had to input each formula manually. How do I keep using the one cell I need as part of the formula, as the divisor? i.e., sum=(a1)/(f12), keeping a1 as the constant divisor, no matter what other cell I use (b7) for example??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
use the number in one cell for different formulas
BTW. You don't need SUM, and A1 is the dividend rather than the divisor
"RlR" wrote: when I copy and paste the formula I want into adjacent cells, it does not retain the particular cell I want to use. I had to input each formula manually. How do I keep using the one cell I need as part of the formula, as the divisor? i.e., sum=(a1)/(f12), keeping a1 as the constant divisor, no matter what other cell I use (b7) for example??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Formulas referencing a spaces instead of number ? | Excel Discussion (Misc queries) | |||
| Letters and Number formulas | Excel Worksheet Functions | |||
| point to one number on each sheet that will be in many formulas | New Users to Excel | |||
Linear Mode
