add same number to a column of numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

djs - 14 Apr 2006 18:59 GMT

How do i add .25 to a column of 15 different numbers at one time instead of
doing it separately.

Reply to this Message

Barb Reinhardt - 14 Apr 2006 19:03 GMT

Let's say you have the 15 different numbers in A1:A20
In B1 put =A1+.25
Copy that down to B20

> How do i add .25 to a column of 15 different numbers at one time instead
> of
> doing it separately.

Reply to this Message

Niek Otten - 14 Apr 2006 19:17 GMT

Or: enter .25 in an empty cell. Edit>Copy.Select A1:A20
Edit>Paste Special, check Add

Signature

Kind regards,

Niek Otten

| Let's say you have the 15 different numbers in A1:A20
| In B1 put =A1+.25
[quoted text clipped - 3 lines]
| > of
| > doing it separately.

Reply to this Message

djs - 14 Apr 2006 19:28 GMT

I want to add the .25 to the same column. i.e if i highlight A1 to A15 then
somehow add +.25 then all the numbers in the A column would increase by .25

> Let's say you have the 15 different numbers in A1:A20
> In B1 put =A1+.25
[quoted text clipped - 3 lines]
> > of
> > doing it separately.

Reply to this Message

Pete_UK - 14 Apr 2006 21:03 GMT

Niek has given you the way to do it.

Pete

Reply to this Message