I'm trying to create a spreadsheet for oil change and tire rotation. I'm trying to find the formula to add a given number to the mileage. For instance, I have the current mileage and I want to add a number amount to let me know the mileage at which I change it. Same for tire rotation

I want to add a given number to the black box that will automatically enter it in the red box

 

=SUM(A13+5000)

Replace A3 with whatever the cell name is for the 69,400 cell

 

Nice, Thanks!

 

you gotta do a formula black box+X= red box (the cell numbers) and carry it down through all of the row.

so example, lets say black box is 21A (location) + your amount for milage (5k)= 21D or red box location.

 

like trent said. i was too slow. copy and paste for all of your row.

 

Theres actually a easier way than copy and pasting. In the bottom right corner you can mouse over and you'll see a sort of plus sign appear. Click and drag that and it will copy the formula in each cell but with the correct cell number for the formula. So if you drag up it will say A12, A11, A10, etc, etc so you don't have to go back and change it.

You'll see what I mean if you try it, its kind of hard to explain.

 

I'm not seein anythign in the bottom right, just zoom,scroll, and page layout

 

Bottom right of the individual cell, not the page. Sorry left that out

 

Ah yeh I see it now haha thats so much better then editing each cell!