Welcome! Please use the navigational links to explore our website.
PartsASAP LogoCompany Logo (800) 853-2651

Shop Now

   Allis Chalmers Case Farmall IH Ford 8N,9N,2N Ford
   Ferguson John Deere Massey Ferguson Minn. Moline Oliver
 
Marketplace
Classified Ads
Photo Ads
Tractor Parts
Salvage

Community
Discussion Forums
Project Journals
Your Stories
Events Calendar
Hauling Schedule

Galleries
Tractor Photos
Implement Photos
Vintage Photos
Help Identify
Parts & Pieces
Stuck & Troubled
Vintage Ads
Community Album
Photo Ad Archives

Research & Info
Articles
Tractor Registry
Tip of the Day
Safety Cartoons
Tractor Values
Serial Numbers
Tune-Up Guide
Paint Codes
List Prices
Production Nbrs
Tune-Up Specs
Torque Values
3-Point Specs
Glossary

Miscellaneous
Tractor Games
Just For Kids
Virtual Show
Museum Guide
Memorial Page
Feedback Form

Yesterday's Tractors Facebook Page

  
Tractor Talk Discussion Board

Re: Excel spread sheet help ?


[ Expand ] [ View Replies ] [ Add a Reply ] [ Return to Forum ]

Posted by steve in in on June 19, 2009 at 06:15:16 from (66.14.205.186):

In Reply to: Excel spread sheet help ? posted by northeast puller on June 19, 2009 at 06:03:20:

For the multiplying, put this into your result field

=a1*b1

This will go in the formula bar above your spreadsheet, to the right of the Fx. So you would select the cell you want the formula in then you would go click on the formula field above the spreadsheet and enter your formula.

a1 would be the unit price and b1 would be the quantity. If you put the result in cell c1, then in order to get a running total of c1 you would put the following formula into d2(the next line where you would want the summary)

=sum(c1,d1)

To propogate this down the spreadsheet, click on the fields you want to propogate and in the lower right corner of the highlighted area will be a little square. When your cursor moves from being a white plus sign to being a solid plus sign, simply drag the cursor down the number of rows you need.

Hope this is as clear as mud. Maybe a bit clearer.


Replies:




Add a Reply

:
:
:

:

:

:

:

:

:

Advanced Posting Options

: If you check this box, email will be sent to you whenever someone replies to this message. Your email address must be entered above to receive notification. This notification will be cancelled automatically after 2 weeks.



 
Advanced Posting Tools
  Upload Photo  Select Gallery Photo  Attach Serial # List 
Return to Post 

TRACTOR PARTS TRACTOR MANUALS
We sell tractor parts!  We have the parts you need to repair your tractor - the right parts. Our low prices and years of research make us your best choice when you need parts. Shop Online Today. [ About Us ]

Home  |  Forums


Today's Featured Article - The Tractor Parade: Story of a Case SC - by Bernie DeLon. On a early fall morning back in 1994, I opened the newspaper and happened to spy an article about a local antique tractor club having their annual show that weekend. ... [Read Article]

Latest Ad: Sell 1958 Hi-Altitude Massey Fergerson tractor, original condition. three point hitch pto engine, Runs well, photos available upon request [More Ads]

Copyright © 1997-2024 Yesterday's Tractor Co.

All Rights Reserved. Reproduction of any part of this website, including design and content, without written permission is strictly prohibited. Trade Marks and Trade Names contained and used in this Website are those of others, and are used in this Website in a descriptive sense to refer to the products of others. Use of this Web site constitutes acceptance of our User Agreement and Privacy Policy

TRADEMARK DISCLAIMER: Tradenames and Trademarks referred to within Yesterday's Tractor Co. products and within the Yesterday's Tractor Co. websites are the property of their respective trademark holders. None of these trademark holders are affiliated with Yesterday's Tractor Co., our products, or our website nor are we sponsored by them. John Deere and its logos are the registered trademarks of the John Deere Corporation. Agco, Agco Allis, White, Massey Ferguson and their logos are the registered trademarks of AGCO Corporation. Case, Case-IH, Farmall, International Harvester, New Holland and their logos are registered trademarks of CNH Global N.V.

Yesterday's Tractors - Antique Tractor Headquarters

Website Accessibility Policy