Substracting from a column

[venus21pam]

Hi,

I have a column of numbers and I want to substract a certain value from
every cell in that column and create a new column with new set of
numbers.
How do I do that?

Thanks,

Venus

 

[Roger Govier]

Hi Venus

Place the number you wish to subtract in a blank cell. Copy that cell.
Mark the range of existing data, Paste Special>Subtract.

or, in a column alongside your data (supposing the data is in column A
and the value you wish to subtract is 5) then
=A1-5
Copy down the column for the extent of your data in column A.


--
Regards

Roger Govier


"venus21pam" <[email protected]>
wrote in message
news:[email protected]...

 

[venus21pam]

Thanks a million Roger, you helped me a lot!

 

[venus21pam]

Oh, one more question:

I want to get an absolute value of all the numbers in the column.
How can I apply the function to the whole column at the same time?

 

[Roger Govier]

Hi Venus

Do you mean you want the Absolute in terms of you want the value of each
cell without the sign e.g. 5 will return 5 and -5 will also return 5?
If so then
=ABS(A1) will give you the absolute of whatever value is in cell A1
Copy down the column with the fill handle and it will change to =ABS(A2)
etc. as you go down.
The fill handle is the small black cross you see whenever you hover the
cursor over the bottom right corner of the cell. Double click it to
repeat the formula down the column.

--
Regards

Roger Govier


"venus21pam" <[email protected]>
wrote in message
news:[email protected]...

 

[venus21pam]

Yes, that's what I meant.
Thanks again.