Thread: row= cell's row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wptech wptech is offline
external usenet poster
 
Posts: 1
Default row= cell's row


I have a spreadsheep of 2 cells that need to be calculated by a third
cell that is on the same row as the other 2 cells. But, the rows are
always different as each row is added. Is there a function for a
formula where the row = the current row that the cell processing the
formula is in? ie.

Instead of:
=B2-(B2*C2)
=Bthisrownumber-(Bthisrownumber*Cthisrownumber)

Is something like this even possible to do? Seems like it should be.
I'm really trying to make this make sense you all. It's hard though as
I'm not a programmer and not that good with excel yet.

Thanks,
Ben


--
wptech
------------------------------------------------------------------------
wptech's Profile: http://www.excelforum.com/member.php...o&userid=36217
View this thread: http://www.excelforum.com/showthread...hreadid=560104