Is there a formula to use to add a quantity to every cell in a column?

I need to be able to add a quantity of 3 to every row in a column.

Any help would be appreciated.

Thanks!

Put 3 in an empty cell, make sure it is the same format that you have in the
original cells so if this is currency format the cell as currency first,
then copy it, select the cells you want to add it to and do editpaste
special and select add


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Marimar" wrote in message
...
Is there a formula to use to add a quantity to every cell in a column?

I need to be able to add a quantity of 3 to every row in a column.

Any help would be appreciated.

Thanks!

You mean you already have a number in each cell and want to add 3 to each
exisiting quantity?

=A1+3
If your data starts in A1 you could use this formula in a new column and
then just copy the formula down.

"Marimar" wrote:

Is there a formula to use to add a quantity to every cell in a column?

I need to be able to add a quantity of 3 to every row in a column.

Any help would be appreciated.

Thanks!

Thanks for your help!

"Peo Sjoblom" wrote:

Put 3 in an empty cell, make sure it is the same format that you have in the
original cells so if this is currency format the cell as currency first,
then copy it, select the cells you want to add it to and do editpaste
special and select add


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Marimar" wrote in message
...
Is there a formula to use to add a quantity to every cell in a column?

I need to be able to add a quantity of 3 to every row in a column.

Any help would be appreciated.

Thanks!

And thanks for your help!

"tim m" wrote:

You mean you already have a number in each cell and want to add 3 to each
exisiting quantity?

=A1+3
If your data starts in A1 you could use this formula in a new column and
then just copy the formula down.

"Marimar" wrote:

Is there a formula to use to add a quantity to every cell in a column?

I need to be able to add a quantity of 3 to every row in a column.

Any help would be appreciated.

Thanks!