| Home |
| Search |
| Today's Posts |
|
#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??? |
| 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 | |||
Threaded Mode
