Range Calculations

J

jzimm

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!
 
S

Sloth

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.
 
J

jzimm

Hello Sloth,

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

Best regards,
jzimm
 
Top