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...
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.
Sorry, yes.
You are my hero.
