Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting formula with absolute cell and relative cell
hello, this is my first time here. a friend suggested that you all
could help me out. here is the situation. i have a set of data which i need to insert a formula for. i need to insert the formula and make sure that one of the cells that the formula is using is abolsute and that the other is relative. example: I have a list of data in column A. A1 contains the number which needs to be absolute. A2:A4 contain the data that should be relative. B will contain the formulas. B2 should be something like this =A2/A1, B3 should be =A3/A1..etc. I decided to approach this by name A1 as MyCell...but i cant seem to make a formula which will include the other relative cells...Help!! thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change a cell reference from relative to absolute | Excel Discussion (Misc queries) | |||
Absolute and Relative Cell References | Excel Discussion (Misc queries) | |||
F4 key does not toggle relative/absolute cell references. | Excel Worksheet Functions | |||
Absolute vs. Relative Cell References | Excel Programming | |||
Relative/Absolute Formula writing in to a cell. | Excel Programming |