Need help calculating formula!

[Brita]

I have a spreadsheet created that have numerous cell
entries with different values in each cell. Like a price
list. What I've been trying to do was create a formula to
add $50 to each cell entry amount without having to
manual add $50 to each entry. I've searched Microsoft
Excel help files and I can't find anything to help unless
I don't know what I'm looking for and that could be the
case. I need to take say the cell value of B5 (which is
say 135 and then add 50 to it) I want to then be able to
apply to entire column. Can someone help me out? THANKS!

 

[Guest]

Hi Brita,
input 50 into any blank cell. Copy. Highlight the range you want to
change, and use Edit - Paste Special - Add

 

[Niek Otten]

In an empty cell, enter 50. Edit, Copy.
Select the cells you require 50 to add to.
Edit>Paste Special, check Add.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Jason Morin]

1. Key the number 50 into an open cell.
2. Copy that cell.
3. Select the column.
4. Edit > Paste Special > Add

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

Type the number 50 in a blank cell. Edit/Copy that cell.

Select the cells to be changed, then Edit/Paste Special, and select the Add
and Values options.

 

[Brita]

Can't anyone point me in the right direction???

 

[Don Guillett]

select a blank cell somewhere>put 50 in that cell>copy>select
column>edit>pastespecial>add

 

[Niek Otten]

Did you check the 4+ replies you got?


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Gordon]

Did you check the 4+ replies you got?

Of course not! The OP is using the CDO interface ;-)