Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Sort with VLOOKUP/LARGE Functions | Excel Worksheet Functions | |||
Percentages | Charts and Charting in Excel | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
Which Function(s) do I use? | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |