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

weighting a cell
 

Kimber,

I am not exactly sure what you are trying to do, but if you would like
to multiply the value of a cell (weight) depending on its position you
could always use the =row() and/or =column() functions.

To apply to your example, if you wanted E4 to have four times the
weight, the formula would be =E4*row(E4).

Hope that helps,

RC


--
JRockdown
------------------------------------------------------------------------
JRockdown's Profile: http://www.excelforum.com/member.php...o&userid=13236
View this thread: http://www.excelforum.com/showthread...hreadid=538593