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

Range Calculations
 

first I assume you mean this formula, because POWER needs two variables.
=POWER(cell,6)

second, you will need to use a helper column. In cell D5 enter this formula
=POWER(C5,6)
then copy down to cell D21. Copy D5:D21 and then right click cell C5 and
select "paste special". Select values, and click OK. Now delete D5:D21.

"jzimm" wrote:


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

Range Calculations
 

Hello Sloth,

Your procedure works perfectly! Thanks very much for the help.

Best regards,
jzimm


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