Adding one colum to the next consecutively

[wilmath]

I have a series of numbers in column A
I have one number in the top of column B.
How do I get calc to add the number from column A to the number in column B and
then repeat the process for all the numbers in column A which will produce a set of numbers in column B?

Thanks

[FJCC]

I will assume the first value in column A is in A2 and the constant value is in B1. The formula in B2 should be

Code: Select all

=A2 + $B$1

Copy that down the column and the A2 will automatically increment to A3, A4, etc but the B1 will not change.