| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Function that references cells to other cells...
No it doesn't. It requires D496 to display the value 119 (or the
appropriate row number) - it doesn't care how that is produced - hard coded or produced by a formula. -- Regards, Tom Ogilvy jayhawk1919 wrote in message ... The "=Indirect("C"&D496)*0.5+Indirect("D"&D496)+Indire ct("E"&D496)*2+Indirect("F " &D496)+Indirect("G"&D496)-Indirect("H"&D496)" formula is easy enough to understand. Thanks a bunch for your help, I have one more question though. Does this formula require the "=Match(C496,$A$1:$A$250,0)" to be in D496? If so, could you explain it so I understand why I need it? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Function to Reference Cells that Contain Certain Values | Excel Worksheet Functions | |||
| references to named cells | Excel Discussion (Misc queries) | |||
| Can references (to cells being sorted) move with the cells? | Setting up and Configuration of Excel | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| working with references of cells | Excel Worksheet Functions | |||
Threaded Mode
