software

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: www.excelforum.com/member.php...oamp;userid=32299
View this thread: www.excelforum.com/showthread...hreadid=520551first 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 D521 and then right click cell C5 and
select quot;paste specialquot;. Select values, and click OK. Now delete D521.

quot;jzimmquot; wrote:

gt;
gt; Hello:
gt;
gt; I would like to select a row of numbers, then perform the same
gt; calculation on each value in each cell with the result replacing the
gt; old value in each cell.
gt;
gt; For example, I have values in cells C5:C21. I would like to take each
gt; individual value and perform the same calculation, =power(cell value -
gt; 6) with the new result replacing the old value in each cell.
gt;
gt; Thanks for any help!
gt;
gt;
gt; --
gt; jzimm
gt; ------------------------------------------------------------------------
gt; jzimm's Profile: www.excelforum.com/member.php...oamp;userid=32299
gt; View this thread: www.excelforum.com/showthread...hreadid=520551
gt;
gt;


Hello Sloth,

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

Best regards,
jzimm--
jzimm
------------------------------------------------------------------------
jzimm's Profile: www.excelforum.com/member.php...oamp;userid=32299
View this thread: www.excelforum.com/showthread...hreadid=520551