Naga,
If you have the following in column A - cells A1:A8,
A
10
20
30
40
4
2
1
3
Add this formula to cell B1 and copy it down the range to cell B8:
=A1-5
The formulas in column B when copied down the range look like this:
A B
10 =A1-5
20 =A2-5
30 =A3-5
40 =A4-5
4 =A5-5
2 =A6-5
1 =A7-5
3 =A8-5
The final output looks like this:
A B
10 5
20 15
30 25
40 35
4 -1
2 -3
1 -4
3 -2
----
Regards,
John Mansfield
http://www.pdbook.com
"naga s chintala" wrote:
say for example i have (10,20,30,40,4,2,1,3) in column A .Now i would like to
subtract 5 from all the no.s or from the entire column A.
so which formula am i supposed to use
"naga s chintala" wrote:
how can i subtract a single integer value from the entire column
say : i wanna subtract 10 from the entire column of numbers