Can I add a quantity to every cell in a column using a formula?

[Guest]

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!

 

[Peo Sjoblom]

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 edit>paste
special and select add


--


Regards,

Peo Sjoblom

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

 

[Guest]

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.

 

[Guest]

Thanks for your help!

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 edit>paste
special and select add


--


Regards,

Peo Sjoblom

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

 

[Guest]

And thanks for your help!

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.