Need help calculating formula!

B

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!
 
M

mzehr

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

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
 
J

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
 
M

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.
 
D

Don Guillett

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

Niek Otten

Did you check the 4+ replies you got?


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top