Who is familiar with Excel? - Ranger-Forums - The Ultimate Ford Ranger Resource


General Ford Ranger Discussion General discussion of the Ford Ranger that does not fit in any other sub-forum.

Reply
 
LinkBack Thread Tools Search this Thread
  #1  
Old 01-29-2010
rangrdangr_4x4's Avatar
Member
Thread Starter
 
Join Date: Sep 2009
Location: St. Louis, IL
Posts: 294
Who is familiar with Excel?

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
Name:  54u45u.jpg
Views: 1
Size:  29.1 KB
Reply With Quote
  #2  
Old 01-29-2010
04blackedge's Avatar
RF Veteran
iTrader: (13)
 
Join Date: Jan 2007
Location: Durham, NC
Posts: 23,426
=SUM(A13+5000)

Replace A3 with whatever the cell name is for the 69,400 cell
Reply With Quote
  #3  
Old 01-29-2010
rangrdangr_4x4's Avatar
Member
Thread Starter
 
Join Date: Sep 2009
Location: St. Louis, IL
Posts: 294
Quote:
Originally Posted by 04blackedge View Post
=SUM(A13+5000)

Replace A3 with whatever the cell name is for the 69,400 cell
Nice, Thanks!
Reply With Quote
  #4  
Old 01-29-2010
morris's Avatar
RF Veteran
iTrader: (5)
 
Join Date: Feb 2008
Location: South Detroit.
Posts: 7,833
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.
Reply With Quote
  #5  
Old 01-29-2010
morris's Avatar
RF Veteran
iTrader: (5)
 
Join Date: Feb 2008
Location: South Detroit.
Posts: 7,833
like trent said. i was too slow. copy and paste for all of your row.
Reply With Quote
  #6  
Old 01-29-2010
04blackedge's Avatar
RF Veteran
iTrader: (13)
 
Join Date: Jan 2007
Location: Durham, NC
Posts: 23,426
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.
Reply With Quote
  #7  
Old 01-29-2010
rangrdangr_4x4's Avatar
Member
Thread Starter
 
Join Date: Sep 2009
Location: St. Louis, IL
Posts: 294
Quote:
Originally Posted by 04blackedge View Post
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
Reply With Quote
  #8  
Old 01-29-2010
04blackedge's Avatar
RF Veteran
iTrader: (13)
 
Join Date: Jan 2007
Location: Durham, NC
Posts: 23,426
Bottom right of the individual cell, not the page. Sorry left that out
Reply With Quote
  #9  
Old 01-29-2010
rangrdangr_4x4's Avatar
Member
Thread Starter
 
Join Date: Sep 2009
Location: St. Louis, IL
Posts: 294
Ah yeh I see it now haha thats so much better then editing each cell!
Reply With Quote
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
Look familiar rolsmojave3 General Ford Ranger Discussion 2 02-10-2008 03:20 PM
This truck looks familiar... fx4me General Ford Ranger Discussion 13 12-20-2006 02:26 PM
Mileage calculating excel sheet NHBubba_Revisited 4.0L OHV & SOHC V6 Tech 7 08-24-2006 10:56 PM
Does this pic look familiar to anyone!!!??? rideac1 General Ford Ranger Discussion 13 03-03-2006 01:20 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -6. The time now is 12:52 AM.


We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.