weighting a cell

  • Thread starter Thread starter kimber843
  • Start date Start date
K

kimber843

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Compare 2 excel sheets -Error Checking of entered names 1
Weighted randbetween text list 3
Border formatting row of cells 22
add a chart in a Add-In 1
Run two macros for two different sheets 11
Modify working code to expand the output. 5
Array with many cells from a row but not in order or together 11

Back
Top