| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Reference
That works perfectly THANKS !!!
-----Original Message----- Hi maybe something like =OFFSET(BEGCELL,16,0) -- Regards Frank Kabel Frankfurt, Germany Don wrote: I am trying to create a formula with a relative reference. I want to name a cell like BEGCELL. Then I want to be able to calculate based on the row of that cell. For example my first formula will be =BEGCELL + (BEGCELL+16 rows same column) then my next formula will be =(BEGCELL+20 rows same column) + (BEGCELL+36 rows same column) and so on. What I'm trying to acieve is that if my row number changes I only have to make one change and the rest of my formulas will adjust. Thanks for the help. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Reference help | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| relative reference | Excel Discussion (Misc queries) | |||
| relative reference | New Users to Excel | |||
| relative reference | Excel Programming | |||
Threaded Mode
