| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
? offset('activecell',,-2,1,1) in Named Formula ?
I have a cell formula as part of a WorkSheet for explaining stats =prob_T^(A9) * (1-prob_T)^(n-A9) I would prefer to use a Name, k, in place of the A9 relative reference, as this would align the WorkSheet with standard stats names & make explanations easier to understand. This name needs return a reference to the cell at at columnoffset(-2) relative to the cell the Name is used in ... the syntax I've used in the subject line is as close as I've got so far ... ?? is this something that can be made to work? input gratefully received Mat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named range in sum formula (indirect, offset, worksheet name) | Excel Worksheet Functions | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| ActiveCell Offset | Excel Programming | |||
| Activecell offset value with formula? | Excel Programming | |||
| ActiveCell.Offset w/ VBA | Excel Programming | |||
Threaded Mode
