ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Automatic Product Functions (https://www.excelbanter.com/excel-worksheet-functions/92991-automatic-product-functions.html)

macabe

Automatic Product Functions
 

I'm trying to set up a seemingly simple product function. What I want
is for all the cells in Row 6 to have a product function, but a
different function per each. What I want is some kind of way to put
the SAME function in each cell, but have some kind of symbol that
automatically enters in the letters. My goal is to have the product of
%4 and %5 where % is the letter of the of the column. I hope this makes
sense... Thanks!


--
macabe
------------------------------------------------------------------------
macabe's Profile: http://www.excelforum.com/member.php...o&userid=35228
View this thread: http://www.excelforum.com/showthread...hreadid=550056


Ron Coderre

Automatic Product Functions
 

MACABE:

It seems like you'll find the information you need from Excel Help:

Search for: references
Select: About cell and range references
Expand: The difference between relative and absolute references.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=550056



All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com