| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using formulas to select cells (Ex: Select every nth cell in a col
Subject just about says it. I am trying to create a complex workbook that
will keep track of customers for my small business. I just need to be able to put formulas in place of the number in a cell location. f(x) being any standard Excel formula, I need D*f(x)* instead of just D*constant* if that makes any sense. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using formulas to select cells (Ex: Select every nth cell in a col
It sounds like you may want the INDIRECT() function?
-- David Biddulph "Lakeview Photographic Services" <Lakeview Photographic wrote in message ... Subject just about says it. I am trying to create a complex workbook that will keep track of customers for my small business. I just need to be able to put formulas in place of the number in a cell location. f(x) being any standard Excel formula, I need D*f(x)* instead of just D*constant* if that makes any sense. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using formulas to select cells (Ex: Select every nth cell in a col
It doesn't make too much sense to me, but maybe you're looking at formulas like
=sumif() or =countif(). Debra Dalgleish shares a lot of information: http://contextures.com/xlFunctions01.html http://contextures.com/xlFunctions04.html or maybe it's time to learn about pivottables? Lakeview Photographic Services wrote: Subject just about says it. I am trying to create a complex workbook that will keep track of customers for my small business. I just need to be able to put formulas in place of the number in a cell location. f(x) being any standard Excel formula, I need D*f(x)* instead of just D*constant* if that makes any sense. Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
| How to select cells (located in a column) for formulas in a row automatically? | Excel Worksheet Functions | |||
| How to select cells (located in a column) for formulas in a row automatically? | Links and Linking in Excel | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Hybrid Mode
