software

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--
venus21pam
------------------------------------------------------------------------
venus21pam's Profile: www.excelforum.com/member.php...oamp;userid=30368
View this thread: www.excelforum.com/showthread...hreadid=500201Hi Venus

Place the number you wish to subtract in a blank cell. Copy that cell.
Mark the range of existing data, Paste Specialgt;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 Govierquot;venus21pamquot; gt;
wrote in message
...
gt;
gt; Hi,
gt;
gt; I have a column of numbers and I want to substract a certain value
gt; from
gt; every cell in that column and create a new column with new set of
gt; numbers.
gt; How do I do that?
gt;
gt; Thanks,
gt;
gt; Venus
gt;
gt;
gt; --
gt; venus21pam
gt; ------------------------------------------------------------------------
gt; venus21pam's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30368
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=500201
gt;

Thanks a million Roger, you helped me a lot!--
venus21pam
------------------------------------------------------------------------
venus21pam's Profile: www.excelforum.com/member.php...oamp;userid=30368
View this thread: www.excelforum.com/showthread...hreadid=500201
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?--
venus21pam
------------------------------------------------------------------------
venus21pam's Profile: www.excelforum.com/member.php...oamp;userid=30368
View this thread: www.excelforum.com/showthread...hreadid=500201Hi 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 Govierquot;venus21pamquot; gt;
wrote in message
...
gt;
gt; Oh, one more question:
gt;
gt; I want to get an absolute value of all the numbers in the column.
gt; How can I apply the function to the whole column at the same time?
gt;
gt;
gt; --
gt; venus21pam
gt; ------------------------------------------------------------------------
gt; venus21pam's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30368
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=500201
gt;

Yes, that's what I meant.
Thanks again. --
venus21pam
------------------------------------------------------------------------
venus21pam's Profile: www.excelforum.com/member.php...oamp;userid=30368
View this thread: www.excelforum.com/showthread...hreadid=500201