View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jzimm
 
Posts: n/a
Default Range Calculations


Hello:

I would like to select a row of numbers, then perform the same
calculation on each value in each cell with the result replacing the
old value in each cell.

For example, I have values in cells C5:C21. I would like to take each
individual value and perform the same calculation, =power(cell value -
6) with the new result replacing the old value in each cell.

Thanks for any help!


--
jzimm
------------------------------------------------------------------------
jzimm's Profile: http://www.excelforum.com/member.php...o&userid=32299
View this thread: http://www.excelforum.com/showthread...hreadid=520551