View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JRockdown JRockdown is offline
external usenet poster
 
Posts: 1
Default 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