Forum Discussion
Excel - Adding a value
Hello,
I am trying to increase the value from column B which is "X" amount and add $15.00 to autocreate in column C (I'd like to use format painter to copy the formula down column C. I otherwise have to manually add the "Monthly Rent" column to create the increase of $15.00 to the "New Rent" column. I am using this for a merge document through Word. Hope this is enough information, thank you for everyone's help.
4 Replies
Hello
Simply:
=B2+15
But first you have to change the cell format to General.
Hello,
I do know how to do that. I guess what I'm trying to figure out is how to do it for each column under monthly rent. Each amount is different so if I do "B2+15" it'll always figure 515+15 which I do not want, it needs to add to B3, B4, B5, B6, etc. but I was hoping to not have to type that in to each column. Does that make sense? Is there a way to copy the formula without having to change each B column?
If you write "column" do you mean "row"?
If so then just make a double-click on the little square in the bottom right corner of cell C2.
