Range Question

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I have a range of numbers. Can I subtract 96 from every number in
that range?

The range of numbers was originally found by formulas. I then copied
and paste (special-values) into another grid. Now I want to subtract
96 from each of those numbers.

Beats me if there is a way.

Thanks
 
I posted to quick. Actually, what I really want to do is subtract 96
from the original range of numbers--the ones with the formulas.
Otherwise i'll just have to figure out a way to put the new values
back into the original grid.

There must be a way to do something to every cell in a grid.

Thanks.
 
I have a range of numbers. Can I subtract 96 from every number in
that range?

The range of numbers was originally found by formulas. I then copied
and paste (special-values) into another grid. Now I want to subtract
96 from each of those numbers.

Beats me if there is a way.

Thanks
Click to expand...


Put 96 in some cell.

Select that cell.

Edit/Copy

Select the range from which you want to subtract 96.

Edit/Paste Special -- Subtract

If the contents of the target cell is a value, the result will be the original
value minus 96.

If the contents of the target cell is a formula, the result will be:

=(original_formula)-96


--ron
 
Thank you so much.

Put 96 in some cell.

Select that cell.

Edit/Copy

Select the range from which you want to subtract 96.

Edit/Paste Special -- Subtract

If the contents of the target cell is a value, the result will be the original
value minus 96.

If the contents of the target cell is a formula, the result will be:

=(original_formula)-96


--ron
Click to expand...
 
Back
Top