Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Question
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. On Mon, 10 Dec 2007 17:11:49 -0800, Peter wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Question
On Mon, 10 Dec 2007 17:11:49 -0800, Peter wrote:
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 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Question
Thank you so much.
On Mon, 10 Dec 2007 20:28:40 -0500, Ron Rosenfeld wrote: On Mon, 10 Dec 2007 17:11:49 -0800, Peter wrote: 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Question | Excel Discussion (Misc queries) | |||
Named Range Question | Excel Worksheet Functions | |||
Named range question | Excel Discussion (Misc queries) | |||
Range question in '97 | Excel Discussion (Misc queries) | |||
Question on LABEL Range | Excel Worksheet Functions |