Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying Formulas
I am working on a spreadsheet that I need to take the data in a cell, subtract another factor, then divide by another factor. Data in Cells: A1: 10 K15: 2 A2: 12 E39: 2 A3: 14 What I need is: =(Info in cell-K15)/E39 =(Info in cell-K15)/E39 =(Info in Cell-K15)/E39 I know how to individually enter the formulas--but I have hundreds to do---and the formulas are all the same except the first number. How do I do this? -- sccspires ------------------------------------------------------------------------ sccspires's Profile: http://www.excelforum.com/member.php...o&userid=24168 View this thread: http://www.excelforum.com/showthread...hreadid=377947 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Error when copying formulas | Excel Worksheet Functions | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
Excel & Copying Formulas | Excel Worksheet Functions |