Thread: Creating a Function that references cells to other cells...
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jayhawk1919[_3_] jayhawk1919[_3_] is offline
external usenet poster
  
Posts: 1
Default Creating a Function that references cells to other cells...
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/

Reply With QuoteReply With Quote