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