View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kimber843 kimber843 is offline
external usenet poster
 
Posts: 1
Default weighting a cell


I have a workbook with 2 sheets - one page(sheet 1) is data entered, th
other (sheet 2) are results for data entered. My question is this, i
there a way to weight the cell (say from sheet 1 cell E4 is to b
weighted 4x's), versus, what I have been doing which is using 4 cells
entering a value of 0(=false) and 1(=true) for each cell and th
average for a certain range of cells is displayed on the results page.
I am using office 2000.
Thanks for any help in advance!
kimber84

--
kimber84
-----------------------------------------------------------------------
kimber843's Profile: http://www.excelforum.com/member.php...fo&userid=3409
View this thread: http://www.excelforum.com/showthread.php?threadid=53859