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!

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!

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